DTS to SSIS Migration

• pavan kumar posani

  SSC Veteran

  Points: 270

  More actions

  May 22, 2008 at 8:08 am

  #188146

  Hi All,

  I am trying to migrate all the sql server dts packages from sql 2000 to sql 2005 box. We are doing an side by side migration. I am very new to this DTS and SSIS and these packages came from my business people and they asked me to migrate this dts packages. I have over 40 packages that need to be migrated to SSIS.

  Could Some body please help me out where to start and some documentation if you guys are having is greatly appreciated?

  Thanks,

  Pavan

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 22, 2008 at 9:24 am

  #819203

  Go here for links to a bunch of articles: http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html

  Download and run SQL Server 2005 Upgrade Advisor to see a what issues you may have with your DTS packages. Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

  Greg