DTS to SSIS migration issue

• vduggaraju

  SSCommitted

  Points: 1643

  More actions

  July 13, 2007 at 8:52 am

  #119774

  Hi,

   

  I am trying to migrate DTS 2000 packages to SQL 2005 SSis using Package Wizard. When I am invoking and after the passing server information of source and destination, while reading the packages it is giving error

  TITLE: Microsoft SQL Server

  ------------------------------

   

  This wizard will close because it encountered the following error:

   

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

   

  ------------------------------

  ADDITIONAL INFORMATION:

   

  Index was out of range. Must be non-negative and less than the size of the collection.

  Parameter name: index (mscorlib)

  Could someone can help in this regards. As this is a important task for me and I am stuck on this which has to be resolved by end of today.

  Thanks

  -VD

  
  venkatesh

• wyliec2

  SSC-Addicted

  Points: 438

  More actions

  July 16, 2007 at 10:15 am

  #719731

  You most likely have a DTS package with a name that the wizard doesn't like.

  I kept getting this error until I found a package that had a space as the last character of the name....