SSIS Import Export Wizard default Column Mappings

• Brian Brown-381342

  Old Hand

  Points: 371

  More actions

  November 9, 2007 at 9:04 am

  #122203

  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.

• Chuck Rivel

  SSCrazy

  Points: 2961

  More actions

  November 9, 2007 at 11:54 am

  #749956

  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.

• Brian Brown-381342

  Old Hand

  Points: 371

  More actions

  November 9, 2007 at 2:04 pm

  #749987

  Thanks Chuck for checking it out, if I come across an answer I'll be sure to post it.

  Brian