March 19, 2010 at 12:07 pm
Hello Everyone
I need some Dts packages to migrate it to sql 2005. Can u please provide me with sample dts packages. I would really appreciate your help. Thank you in advance
March 19, 2010 at 12:22 pm
SQL 2005 does not use DTS, SQL 2005 uses SSIS packages, they are totally different than DTS.
If you want samples of SSIS packages, they come with SQL Server 2005
Andrew SQLDBA
March 19, 2010 at 1:06 pm
I need sample dts packages to migrate them to ssis.
March 19, 2010 at 1:09 pm
I just told you. There are no DTS Packages in SSIS. There is no migrating anything. You cannot simply "migrate" a DTS package to SQL 2005. You can re-write it using SSIS.
If you do not believe me, create one in SQL 2000 and try
Andrew SQLDBA
March 19, 2010 at 2:07 pm
At least SSIS 2008 has a Migration Wizard, I can only assume 2005 had one also before it.
Details on using it are here.
Why ask everyone for samples? Obviously you're not looking for support of a particular scenario being upgraded to SSIS, so why not simply create your own DTS packages and then upgrade those?
Steve.
March 19, 2010 at 2:19 pm
2005 also has a migration wizard.
Here is an article that may serve some usefulness.
http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply