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.
Subscribe to:
Post Comments (Atom)
Free Power BI Classes for Week 7 (Last)
Just completed the last class of the F ree P ower BI classes of this series. Today we have covered Adding a canvas background Adding Imag...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
2 comments:
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
Convert DTS to SSIS
Post a Comment