20 pts.
 Create text file to OS400 folder by using Microsoft SQL Server 2005
Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command to create output file at OS400 folder. Thanks for reply

Software/Hardware used:
ASKED: March 31, 2009  8:40 AM
UPDATED: March 31, 2009  5:23 PM

Answer Wiki:
Instead of trying to create the folder on the mapped drive, create the file on the OS400 folder using the full network path to the folder. You will need to make sure that the SQL Server is running under a domain account and that, that account has rights to the network share on the OS400 machine.
Last Wiki Answer Submitted:  March 31, 2009  5:23 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _