This post originated from an RSS feed registered with .NET Buzz
by Raymond Lewallen.
Original Post: DTS migration to SSIS
Feed Title: Raymond Lewallen
Feed URL: /error.htm?aspxerrorpath=/blogs/raymond.lewallen/rss.aspx
Feed Description: Patterns and Practices, OOP, .Net and Sql
From Tom Rizzoâs blog, here is some news
I knew I would have to go looking for sooner or later but I just
havenât had time to go research SSIS regarding whatâs going to be
involved in converting DTS packages.
Q) How do I move to SSIS? A)
It's a migration. We have a migration wizard that will take your
DTS packages and migrate them to SSIS. The thing you have to
remember is that SSIS is not a minor upgrade to DTS. It's a
re-write to make SSIS super scalable and have great performance and
functionality. The good thing is that we still ship the DTS 2000
runtime in certain versions of SQL Server 2005 so you can continue to
run your DTS packages even as part of a SSIS workflow.