April 15, 2002 at 8:23 am
Hi all,
I am trying to import a database 'SUPPLIERS' from our live server to a backup server. This is not the only database that I’m backing up but it is the only one that errors(error in double quotes). Can anyone tell me how to set IDNITITY_INSERT ON? Or any other suggestions that might prove helpful
"An explicit value for the identity column in the table 'SUPPLIERS' can only be specified when a column list is used and IDNITITY_INSERT is ON"
TIA,
Wade.
April 15, 2002 at 10:21 am
I have never done this before or needed to but the following should work. Create a query task that is executed first with SET IDNITITY_INSERT ON then run the import and finally a query task SET IDNITITY_INSERT OFF, the setting should stay in effect for the duration of the connection of the DTS package.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 15, 2002 at 11:02 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply