Browse by Tags

SSIS Lab: Runtime Performance Differences Between DTS and SSIS

Even though you can indeed run DTS packages from within SSIS the solution is only partially complete. In Management Studio, you can manage your DTS packages under Managment --> Legacy --> Data Transformation Services. From here, you can open packages, import new ones but you cannot create a new...

Posted to Brian Knight (Weblog) by Brian Knight on 03-12-2008
SQL Server 2005 with SSIS must be installed before installing DTSxChange

I've downloaded DTSxChange v1.6, but I'm running into a problem... I get the message "SQL Server 2005 with SSIS must be installed before installing DTSxChange" when attempting to install, even though I have SQL Server 2k5 and SSIS installed. I am, however, running 64bit Vista... is...

Posted to DTS xChange (Forum) by ddarden42 on 11-14-2007
DTS xChange Rules: NULL Handling

Coming in version 1.6.

Posted to DTS xChange Help (Weblog) by Brian Knight on 11-05-2007
DTS xChange Rules: Logging to SQL Sever

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. Package logging is turned off by default in SSIS. By checking...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007
DTS xChange Rules: Logging to Text

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. Package logging is turned off by default in SSIS. By checking...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007
DTS xChange Rules: Wrap the Package in Transaction

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. By enabling this rule, all converted packages will be wrapped...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007
DTS xChange Rules: Add Checkpoints

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. By enabling this option, your packages will be have the checkpoint...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007
DTS xChange Rules: Consolidate Connection Managers

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. By enabling this rule, duplicate connections will be consolidated...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007
DTS xChange Rules: Event Handler Logging

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. The Event Handler Logging rule enables logging into a descriptive...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007
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...

Posted to DTS xChange Help (Weblog) by Brian Knight on 09-24-2007

Page 1 of 2 (13 items) 1 2 Next >