Is there a way to view SQL Server 2000 DTS files like on a IDE

Hi Friends,

I have to open and see DTS packages on desinger to figure out an migration error...but to do this SSMS 2008 with DTS Desginer components is not working its throwing some unhandled error.

So just thinking if we can open it in some kind of IDE so that I can figuegure out error.

OS i am using is Windows 7

more ▼

asked Aug 23, 2011 at 11:11 PM in Default

pvsrinivasrao gravatar image

174 26 27 27

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
You could install the old SQL Server 2000 client tools, which includes the DTS Designer. I would then suggest to look at migrating the DTS packages to SSIS.
more ▼

answered Aug 23, 2011 at 11:37 PM

WilliamD gravatar image

25.9k 17 19 41

+1 here is the MSDN link [How to: Install Support for Data Transformation Services Packages][1]

[1]: http://msdn.microsoft.com/en-us/library/ms143755.aspx
Aug 24, 2011 at 12:58 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 23, 2011 at 11:11 PM

Seen: 1308 times

Last Updated: Aug 24, 2011 at 12:48 AM