in

Pragmatic Works

Enabling your business intelligence enterprise.

DTS xChange Help

DTS xChange Rules: Convert Child DTS Packages to SSIS Packages

DTS xChange has a series of enterprise-ready rules to help you migrate your DTS packages to SSIS quickly and easily. After you select the packages that you wish to migrate, you then specify the rules on the Specify Rules screen in the wizard.  

If this rule is enabled, DTS xChange determines if you have Execute Package Task inside a DTS package, and automatically converts the children packages to SSIS as well and stores them in the location of your choice. The Execute Package Task will be converted to its SSIS equivalent. By not enabling this feature, we will keep the package as a DTS package and convert the Execute Package Task to an Execute DTS 2000 Package Task.

Convert Child Packages Options

The rule tab configures where to output the children packages once they are migrated.

  • Default - outputs the children packages to the same location as the parent packages.
    • Server - The SQL Server that contains the msdb database where you want to store the packages
    • Packages Path - The folder in the package store where the packages will be stored.
  • Store SSIS Packages on SQL Server - Outputs the children packages to a specific SQL Server.
  • Store SSIS Packages on File System - Outputs the children packages to a specific folder.
    • File location - The location where the packages will be stored.

Comments

No Comments
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems