Post reply

Bulk Insert with Format File

  • September 13, 2010 at 3:21 pm

    #1220326

    Just leave the date off if the date column is nullable. If it's not nullable, you should specify a default for it.

    10.0

    6

    1 SQLCHAR 0 100 "\t" 1 Agent SQL_Latin1_General_CP1_CI_AS

    2 SQLCHAR 0 100 "\t" 2 Target_Id SQL_Latin1_General_CP1_CI_AS

    3 SQLCHAR 0 100 "\t" 3 Performance SQL_Latin1_General_CP1_CI_AS

    4 SQLCHAR 0 100 "\t" 4 CountNum SQL_Latin1_General_CP1_CI_AS

    5 SQLCHAR 0 100 "\t" 5 Availability SQL_Latin1_General_CP1_CI_AS

    6 SQLCHAR 0 300 "\r" 6 Alias SQL_Latin1_General_CP1_CI_AS

    And then again, I might be wrong ...
    David Webb

  • September 13, 2010 at 4:10 pm

    #1220351

    Hi,

    Thank you very much ...I got it right ...

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

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