Post reply

bcp in DTS?

  • May 24, 2002 at 7:19 pm

    #104959

    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

    #429764

    Yes, there is a BCP task that you can use in DTS.

    Steve Jones

    steve@dkranch.net

  • May 27, 2002 at 5:25 pm

    #429805

    Would you suggest where or how to specify the NATIVE format for the output file?

  • May 29, 2002 at 1:24 pm

    #429948

    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