May 24, 2002 at 7:19 pm
Hello,
I need to create a set of the data files from the views in the sql server2000
and send this set to the customer who also happen to have sql server2000.
I would like to create the datafiles in the sql server native format (-n option in bcp) because I have some 'bad' characters in the data (such as new line character).
Can I do it in DTS Designer?
thanks!
May 24, 2002 at 10:21 pm
May 27, 2002 at 5:25 pm
Would you suggest where or how to specify the NATIVE format for the output file?
May 29, 2002 at 1:24 pm
I finally found out how to do it!
I used the following call in Execute SQL Task
EXEC master..xp_cmdshell "BCP mydb..DETAIL out detail.dat -fD:\DETAIL.FMT -T"
Hey, took me sometime...
All is well that ends well...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply