• Hi,

    I dont have any special Issues, but it's good if you re-create Linked server after you upgrade your sql server and after you migrated Logins and SIDs to new server.

    With regards to DTS package migration, there are 3 methods

    1) Run the DTS package in SSIS using backward compatibility feature

    Pros: if you have any legacy application/legacy feature that needs to run ONLY DTS package

    Cons: you can't use the latest features and advances in the SSIS package, for ex: if there is an ODBC connection which connest and pulls millons records iinto sql server destination, then after you upgrade you can use OLEDB or native connection to pull the records which is much faster that legacy method

    2) Upgrade the DTS package using the DTS upgrade wizard which you find thru SSMS object explorer --> Management --> Legacy --> DTS --> right click on the individual DTS package and select the option MIGRATE. This method will automatically upgrades to newer version, if there are some ActiveX Scripts you have to re-create them seperately, you have no choice (to my knowledge, plz confirm this with soem one else too .... just to make sure)

    Pros: Easy to migrate, less effort

    Cons: If you have many legacy tasks like ActiceX Script, it will be tideous to re-create all the broken pieces

    3) Re-create the whole SSIS package, which is similar to DTS package with same source and destination and same transformations

    Pros: Very straight forward and 100% success if you properly work on the creation of new SSIS package

    Con: Time consuming, but it's worth to spend such time on this

    Here is the referenec giude on the DTS MIgration:

    http://www.infosys.com/microsoft/resource-center/Documents/DTS-SSIS-2008-migration.pdf

    Hope this might help you or atleast some intilative. Let me know if I can give more info, to my knowledge

    Thanks