Thursday, August 06, 2009

Converting DTS to SSIS in SQL SERVER 2005

The easiest way to convert your SLQ SERVER 2000 DTS packages to SSIS is to use a tool called 'DTS xChange' that is available for download here

Here is link to the webcast by Brian Knight of Pragmatic works explaining in detail as to how to proceed with the DTS xChange tool.


martha said...

I recently came accross your blog and have been reading along. I thought I would leave my first comment. I dont know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.


JanuskieZ said...

Hi... Looking ways to market your blog? try this:

Yogendra Oza said...

Hi Priya,

Its a nice blog as well as good information about Brian Knight, and DTSxChange.

Yes, It is a good tool to convert DTS Packages to SSIS.

You can download it from

Yogendra Oza

Yogendra Oza said...

Convert DTS to SSIS

Did you know that you could export data from different SSRS Tablix into different excel sheets of a workbook?

Today I had a requirement from one of my customer to export data from two different tables generated out of SSRS reports into two different...