Post reply

Bulk Insert with no Delimiters

  • April 25, 2003 at 11:17 am

    #80748

    Hello,

    I am trying to do a bulkinsert with no delimiters. i.e. I want to specify the length of the column breaks. I am using a format file:

    8.0

    15

    1SQLCHAR214""1junk1SQL_Latin1_General_Cp1_CI_AS

    2SQLCHAR25""2OrigTimeSQL_Latin1_General_Cp1_CI_AS

    3SQLCHAR23""3OrigDateSQL_Latin1_General_Cp1_CI_AS

    Notice I put blanks in where the delemiter would normally be... This obviously does not work. Help?

  • April 25, 2003 at 12:05 pm

    #455419

    Did you create the format file manually, or use the bcp utility to create it? Also, have you tried to set up a DTS job w/ a bulk insert object? This allows you to use the GUI to specify field lengths. If you do not want to use DTS, check out the bcp utility for creating format files in BOL. You may have to play around with it, but it works.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • April 25, 2003 at 12:12 pm

    #455421

    Thanks,

    I just got it working. Had to mess around with the field lengths. But, it works fine now

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply