Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012

Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012

Rate This
  • Comments 8

SQL Server Integration Services (SSIS) 2012 doesn't support migrating or running DTS packages.  You do have the following options for migrating your DTS packages to SSIS 2012.

 

  • Recreate the SQL Server 2000 Integration Services packages by using SSIS 2012. The What's New in Books Online provides an overview of the new features in SSIS 2012. The Integration Services (SSIS) Packages topic describes the elements of an SSIS package.

 

Here is a list of the DTS functionality that has been discontinued in SSIS 2012.

  • DTS runtime

  • DTS API

  • Package Migration Wizard for migrating DTS packages to the next version of
    Integration Services

  • Support for DTS package maintenance in SQL Server Management Studio

  • Execute DTS 2000 Package task

  • Upgrade Advisor scan of DTS packages.

Leave a Comment
  • Please add 8 and 1 and type the answer here:
  • Post
  • Thanks a lot for your Tips, I am about to migrate my DTS packages to SQL Server 2012, So If i don’t have SQL Server 2005 or SQl Server 2008 what are my options ?

    I will appreciate your help

    Many thanks

    Syed

  • You may want to check with the Pragmatic Works about using DTS xChange to migrate your DTS packages.

  • How about ActiveX?. Can one migrate DTS Packages with ActiveX scripts from SQL 2000 to SQL 2012 automatically or manually the only way to accomplish this?

  • Thank you very much for this information. We are currently testing SQL 2012 in our development environment. DTS is on the list of subjects, and this will help us a lot with our decision making.

  • As a migration always means a planned downtime and is a very special phase in

    the life of an SAP system, ease of use and a save process are more important

    than reducing the downtime to the absolute minimum. The most important

    recommendation we would like to provide is to use only the optimizations

    <a href="saptrainings.com/.../">SAP OS DB MIGRATION ONLINE

    TRAINING</a>

  • I will recommend you site for freshers and starters, they will get brief information on sap. I am an sap os db professional and we give SAP OS DB MIGRATION ONLINE TRAINING .

    If at any stage of the SAP software life cycle you should need to change your operating system and/or database, the SAP OS DB MIGRATION ONLINE TRAINING Check optimally prepares you for a successful migration and supports smooth continued operations on the new platform. The SAP OS DB MIGRATION ONLINE TRAINING is mandatory if you are going to migrate a productive system.

    <a href="saptrainings.com/.../">SAP OS DB MIGRATION ONLINE TRAINING</a>

  • Information about SAP OS DB MIGRATION ONLINE TRAINING is really worth for the readers. Please feel free to redistribute in aid of providing useful information to a wider audience.

    This article information was so nice.Ease of use and a save process are more important

    than reducing the downtime to the absolute minimum. The most important

    recommendation we would like to provide is to use only the optimizations.

    <a href="saptrainings.com/.../">SAP OS DB MIGRATION ONLINE TRAINING</a>

  • The information that you provided is great. I will recommend you site for freshers and starters,

    they will get brief information on sap.

    The elements of services, tools and documentation form the basis for

    successfully executing the migration. The tools support the R3load procedure.

    The services include guidance during migration planning, hotline support for the SAP tools, and an

    SAP operating system or database migration check.

    <a href="saptrainings.com/.../">SAP OS DB MIGRATION ONLINE

    TRAINING</a>

Page 1 of 1 (8 items)