Convert your old DTS Packages with DTS xChange

September 28, 2011

In my last post I told you about DTS xChange Profiler and how it can help you plan and budget a DTS to SSIS migration.  Now that the planning is done, and hopefully you now have the approval to go ahead with the project, let’s talk about how DTS xChange can now help you actually convert the DTS packages to new SSIS packages.  When you launch DTS xChange from the start menu you will see a menu with 3 options, Profile, Convert and Monitor.  We are going to choose Convert.


On the next screen we will tell DTS xChange where our DTS packages reside, either on a file system or on SQL Server. Once we have navigated to the folder containing our packages we next have to specify where the converted SSIS packages will be stored, again this can be either on a file system or on SQL Server. You will also need to tell DTS xChange what the target SSIS platform is, in my case it is SQL Server 2008.


You must also specify if you are planning to run the package on a 64 bit machine or not, but don’t worry if you don’t know there is an option for that too.  There are also some advance options you can configure on this screen as well.

Once you have set the source and destination for your packages its time to select the packages you want to convert.


On this screen you can see w have a list of all the DTS packages in the location we specified.  There are several options we can use to select the DTS Packages we want to convert.  My two favorite buttons on this whole screen are the Select All and the Unselect All, simply because of the convenience factor.  It annoys me to no end when there is a multi-select list and no ability to do either.  There is also a search bar at the top which will allow you to find a specific package.  Once you have selected the packages you want to convert they will appear in the pane on the right.  For convenience you can choose to remove packages from that list by highlighting it and click on the remove button, or you can uncheck the package from the list on the left.  Finally you can select Remove All to start the selection process over.  Once your list is set to your satisfaction you can move on to the next screen.


This section allows you to institute some best practices and also configure the migration settings. You can navigate through the different sections by either clicking on the tabs across the top or the list on the left. There are thirteen tabs you can configure in this section, but for brevity I’ll just walk you through the first few.  In the first screen you can set the options for creating configuration file including location of the files and whether they are package or connection configurations.  The next tab configures settings for child packages.  The Auditing Framework tab allows you to add an auditing framework into the newly created packages.  All of these tabs allow you to add additional functionality or best practices into you new packages. Once your done configuring the Best Practices and Migration Settings click next.


Verify the list of packages that will be converted and click Start Migration.  As the migration progresses you will see the statistics in the Migration Summary pane be updated. Once the packages have finished migrating you will get a Migration Alerts window to pop up which will allow you to review and warnings or errors that occur during migration.


By clicking on the Migration Alerts Hyperlink you can see the details of those warnings.


The messages you want to pay particular attention to are the Critical Warning and the Error messages. Once they have been reviewed you can choose to save a log of the messages and then click close. That is pretty much it.  Instead of having to manually select the components to replace the existing DTS package components, rewrite SQL statements etc.. or run through the wizard and in next to no time you can convert your DTS packages to SSIS using DTS xChange. 


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: