bulk sql insert task can do tables with identity?

 

 

 i got some bulk insert tasks in SSIS inserting into some tables with identity set ON....

in 1 column. Can the bulk insert task go smoothly

 PS: i cannot find anywhere in the bulk insert task that can set the ignore identity columns...........

 

 

now my steps are prepare database -> create database -> bulk insert into tables

working on my previous problem, Jamie.



Answer this question

bulk sql insert task can do tables with identity?

  • Divac

    Open the Bulk Insert Task, select the Options page, select Options, open the drop down. Check "Enable Identity Insert".

  • bulk sql insert task can do tables with identity?