SQL Table Output to txt file

[Jimmy2128]

I have a table with customers information that updates updates twice a day (SQL Job) for our shipping software. I need to be able to export the table as .txt file to imported into the shipping software. Can you please tell me how can I create an output store precedure...

Thanks\

Jimmy

 

[JayKusch]

You would have to execute BCP within your stored procedure to accomplish this. Something like ...

EXEC Master..xp_CmdShell 

'BCP "SELECT * FROM CustomerTable" queryout customers.txt -n -t, -S MyServer -U MyUser -P MyPass'

You will need to fill in the MyServer with your servername, MyUser and MyPass with the appropriate security credentials.

You could also look into using DTS. With DTS you have much more flexibility, control and an added feature of being able to email alerts or progress reports via email if you set up an email account to be leveraged by DTS and SQL Server.

Thanks

J. Kusch