asked on BCP works fine but dosen't work
This command runs without error
Exec master..xp_cmdShell 'bcp "select * from MyDB.dbo.ftpinf" queryout C:\test.txt -c -T'
the bcp runs fine. No errors but also no file is created?!!?
heres the result
NULL
Starting copy...
NULL
4 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1 Average : (4000.00 rows per sec.)
NULL
Any ideas??
Exec master..xp_cmdShell 'bcp "select * from MyDB.dbo.ftpinf" queryout C:\test.txt -c -T'
the bcp runs fine. No errors but also no file is created?!!?
heres the result
NULL
Starting copy...
NULL
4 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1 Average : (4000.00 rows per sec.)
NULL
Any ideas??
Microsoft SQL Server 2005Microsoft SQL Server 2008
Last Comment
Jan Mishkin
Are you running the commands directly on the server or on a client ? This command will place the output file on the c drive of the sql server, not on the c drive of your client where you are running ssms.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Try a drive and folder not on C:\ root