Browse by Tags

• SSIS
• SSIS FAQs

• How to migrate parameterized DTS packages to SSIS (i.e. Parameters passed using command line from SQL Server Job)?

  Many times we get this question "How do we handle parameterized packages using DTS xChange?" Parameterized package means package executed from command line with parameters passed to it. Most common parameters are global variable initial value... Posted Nov 13 2008, 10:16 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS, dts

• How can DTS xChange save time and money?

  DTS xChnage is developed by a team of experienced developers/DBAs who have great experience with DTS to SSIS migration and they have migrated thousands of packages. So they understand the pain of migration process and they have already faced all challenges... Posted Nov 13 2008, 10:15 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS, dts

• Is there any 3rd party tool available in the market other than DTS xChange to help with DTS to SSIS migration?

  No - Only available option is DTS xChange or inbuilt MS DTS Migration Wizard But study suggests that MS Migration Wizard Success Rate is very low. DTS xChange has several enhancements and new features compared to MS DTS Migration Wizard which saves significant... Posted Nov 13 2008, 10:14 PM by Nayan Patel with | with no comments Filed under: SSIS FAQs, SSIS, dts