THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

A tool to improve DTS to SSIS migration

I wrote a small tool to improve the migration from SSIS to DTS. The problem I had to solve was this: I have many Data Transform Tasks that have a simple behavior, read data from a query and write data on a table, using fast load with batch insert.

You say: why not to use the SSIS Migration Wizard? This is exactly what I want to do, but unfortunately I used UDL files into my package and the migration wizard do not migrate them and leave embedded a legacy DTS package for each Data Transform Task.

My idea was to modify the DTS changing properties where needed, and my tool (DtsToSsisPrepare) generate a new DTS file that can be better migrated to SSIS.

This is the command line help:

Dts to SSIS Prepare
Syntax: DtsToSsisPrepare.exe [switch:value]
     Consolidate UDL connections into regular connections
     Optimize connections recycling the same connection for several tasks
     Remove advanced transformations phases from Transform Data Task
     Reset Maximum Error Count property from Transform Data Task
     Source DTS file name
     Destination DTS file name
     show help
     Activate all conversion features


The best way to use the tool is to specify /all to enable all conversions.
DtsSource and DtsDestination are mandatory parameters.

I wish to write an article explaining the tool behavior in the coming days, in the meantime I'd like to receive feedback on this. Full source code and binaries are downloadable on Enjoy!

Published Sunday, June 25, 2006 8:17 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Sankar said:

Hi , i dowloaded the application.

But when i was trying run the exe its failing with message saying "dtstossisprepare has stopped working "

can you please guide how to correct this

January 7, 2015 5:31 AM

Marco Russo (SQLBI) said:

Sorry it could be many reasons - maybe you don't have some library. Unfortuately, I don't have an environment to test that app anymore.

January 7, 2015 5:35 AM

Haroon said:

i am also getting the same error. The exe file is not executing and throwing the error "dtstossisprepare has stopped working ". Please guide me.

January 7, 2015 5:39 AM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement