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.

4 comments:

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.


Susan

http://8080proxy.com

JanuskieZ said...

Hi... Looking ways to market your blog? try this: http://bit.ly/instantvisitors

Yogendra Oza said...

Hi Priya,

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

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

You can download it from http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange/DTSxChange-Download.aspx

Yogendra Oza
www.DTS-TO-SSIS.com

Yogendra Oza said...

Convert DTS to SSIS

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...