SQL Server Performance

How to migrate DTS packages to SSIS

Discussion in 'SQL Server 2005 Integration Services' started by tboonleong, Mar 13, 2007.

  1. tboonleong Member

    How to migrate DTS packages to SSIS?Anyone know how to do this?Thanks
  2. dineshasanka Moderator

    YOu can use Package Migration Wizard
    http://msdn2.microsoft.com/en-us/library/ms143501.aspx

    There are some issues on this wizardhttp://msdn2.microsoft.com/en-us/library/ms143462.aspx


    few more resources
    http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/
    http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1216481,00.html
    http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page