locked
How to Migrate DTS (or SSIS) packages to Sql server 2016 RRS feed

  • Question

  • Hi There,

    We have an existing web application of sales of customers in which the back end data is maintained in the form of sql databases. They are nearly 50 databases and we have a fresh server in which we have to work remote. Our client want us to Migrate the total databases and DTS to SSIS packages, from the existing server(SQL server 2008 R2) to the new server (SQL server 2016).

    We have several DTS packages (in 2000) since the data is too old and we need to convert those DTS packages to SSIS packages, we are working with it. 

    What are the points need to be considered while migrating those SSIS packages (Which are not Converted yet from DTS) to the new server? Suggest us the best plan to migrate DTS or SSIS without any issues in SQL server 2016.   


    • Edited by chandu.muzik Thursday, November 10, 2016 9:22 AM
    Thursday, November 10, 2016 9:21 AM

Answers

  • Hi,

    Migrate from DTS (SQL Server 2000) to SQL Server 2008 by opening the DTS project in BIDS.

    From SSIS 2008 migrate all to 2016 the same way.

    QA and deal with any issues as they occur.

    I can say some people reported Script Tasks not working to resolve which it was sufficient to open and close them

    In general migrating from 2008 to 2012 and then to 2016 is smoother.

    Almost certainly you will need to rewrite a few small things.

    Some Tasks/Components are unsupported.

    Migrate between equal editions (i.e. fr Enterprise to Enterprise).

    Lastly Good Luck!


    Arthur

    MyBlog


    Twitter

    • Marked as answer by chandu.muzik Monday, November 14, 2016 9:22 AM
    Thursday, November 10, 2016 2:14 PM