November 3, 2008 at 5:03 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.
If any notes or any thing that can help me out by this problem plz provide me.
Thanx in advance.
Regards,
Ifti.
________________________________________
M.I.
[font="Times New Roman"]
November 4, 2008 at 5:07 am
Hello
You have some way to import old dts packages.
Method 1. Save all old dts package, and next import to the sql2005
(this is slow and not to effective).
Method 2. Go to Management studio this location:
Management\Legacy\Data Transformation Services
right click and Migration wizard. Follow the instruction.
If chose this way you found the old dts packages in ssis. (Make a new project, add a package task and select sql server source. You fount there the old dts.)
But first run the Upgrade Advisor Analysis Wizard!
I hope this help you, and sorry for my english. 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply