I'm gonna see if the data dump file can be different, it comes from an external company.

I am creating scripts for a project that will run weekly for several...

thanks for the help.

So should I try:

bcp kroll..cdg9525_bri01208Training_Export in d:\_krollBat\AllData.txt -S meathead-pc\sqlexpress -U sa -P password -w -t¬ -k -F 2

Am on a training course, will try when I...

Just got xp_cmdshell working !

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

Hi

thanks for all the replies

unfortunately xp_cmdshell is an advanced option and I cant use it. I think its because I am using sql server express

I added -e errorfile.txt and...