SQL Server Performance Forum – Threads Archive

How to migrate DTS packages to SSIS

How to migrate DTS packages to SSIS?Anyone know how to do this?Thanks

---

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/

---

]]>