November 3, 2008 at 3:45 am
Hi,
I m a newbie, one of our client is using application based sql server 2000 db. Now the requirement comes to migrate application and db to a new running sql server 2005. And DTS packages already have. But the problem is that my manager has told me to 'perform analysis of each of these jobs with a view to creating a migration strategy for their upgrade to SSIS.' So i want to know in which point of view i want to analysis it. I haven't work on SSIS serverice before this.
Thanx in advance.
Regards,
Ifti.
________________________________________
M.I.
[font="Times New Roman"]
November 3, 2008 at 10:30 am
The SQL Server Upgrade Advisor can give you a list of things that will need to be changed to upgrade a DTS package to SSIS. If you still have the packages in a SQL 2000 instance, you should run the SQL 2005 upgrage Advisor http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&DisplayLang=en.
This will give you a starting point. There are also lots of How-to articles about migrating DTS to SSIS. A Google search will find them for you. I'll tell you this is a complex subject that may require some total package rewrites if the packages are very complicated. We started our migration planning in January and we're still not done migrating all our packages.
Greg
November 4, 2008 at 7:08 am
I also want to point out that you can run SQL 2000 DTS packages in the SQL 2005 environment without converting them to SSIS. This may be an interim solution while you are in the process of converting the DTS to SSIS. There is also an add on component from MS that will permit you to modify DTS packages within the SQL 2005 environment. It is available for 32-bit; not 64-bit. I believe it has some limitations, but I have used it a few times and have not experienced any issues.
November 4, 2008 at 8:51 am
Good point, Ed. I use the DTS editor a lot since we still have many DTS packages in our SQL 2005 instances. Almost all of our production packages running in jobs are still DTS.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply