Import Export Wizard mapping files

• schep021

  Hall of Fame

  Points: 3538

  More actions

  November 21, 2013 at 9:41 am

  #285512

  Hello experts,

  I am running Microsoft SQL Server 2008 R2 (SP2) 64-bit on Windows 2008 R2 SP1 and having troubles getting the Import/Export Wizard to work.

  My goal is to export from a 2005 instance and import into this instance. In addition, to change all varchar columns to nvarchar. I know this can be done manually for each column via the wizard but would really like a more automated solution.

  So, I updated the following files (to cover both x86 and x64 version wizards):

  C:\Program Files (x86)\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML

  C:\Program Files (x86)\Microsoft SQL Server\100\DTS\MappingFiles\SqlClientToSSIS.XML

  C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML

  C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\SqlClientToSSIS.XML

  I changed varchar from having a DataTypeName of DT_STR to DT_WSTR.

  Is this the right way to go, or am I supposed to keep varchar "mapped" to DT_STR and update DtwTypeConversion.xml instead?

  (C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DtwTypeConversion.xml

  C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DtwTypeConversion.xml)

  I did restart the SQL Server service hoping that changes would take affect then, but they did not.

  I am using SQL Server Native Clent 10.0 for both source and destination.

  Thank you in advance for your time!