SQL Server Performance Forum – Threads Archive
Tool for converting DTS package to SSIS
Hello,Which tool could be used for conversion of DTS package to SSIS?
Thanks.
Refer to the SQL 2005 books online for the topic ‘Migrating Data Transformation Services Packages’ for more information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
There is a tool released by microsoft.
But many occasions, I had to rewrite whole thing again for SSIS. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Only basic packages can migrate but if it has any transformation or activex scripts it will not work… Until you recreate your packages as ssis packages you can install dts addon on SQL 2005 machine. http://www.microsoft.com/downloads/…60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Microsoft SQL Server 2000 DTS Designer Components
Mohammed U.
yes. that is exactly what I did.
—————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
That is another compulsion from Microsoft to work with SSIS and fading out the DTS, I feel in order to get latest features you should get used to newer products. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thank you. May be any ready-to use solution exists except Microsoft one?
I haven’t come across any.
anyway did you try Ms one some resources for you
http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/
http://www.sqljunkies.com/WebLog/sqlbi/archive/2006/06/25/22017.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
You might see for any third party tools, but I haven’t seen any such so far. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
http://www.databasejournal.com/features/mssql/print.php/3615516
http://msdn2.microsoft.com/en-us/library/ms143462.aspx
http://www.quepublishing.com/articles/article.asp?p=605035&seqNum=2&rl=1 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Thanks a lot for the help!
]]>