November 9, 2007 at 9:04 am
When using the SSIS Import Export Wizard the default Column Mappings is set for Append Rows and NOT Enable identity; I would like to change the default to Delete Rows and Enable identity insert but can't seem to find where that is done. First hunch is perhaps some XML that needs changing. Thank you for any help or suggestions.
November 9, 2007 at 11:54 am
Brian
The only thing I can see is the program that runs the wizard is located in the following directory (assuming a standard installation):
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe
There are no XML or Config files associated that would allow you to make a change to this setting, at least none that I can see.
Sorry I could not offer a better answer.
November 9, 2007 at 2:04 pm
Thanks Chuck for checking it out, if I come across an answer I'll be sure to post it.
Brian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply