Open DTS package on SQL Management studio 2008

How to open DTS packages which are written in SQL Server 2000 or 2005 in SQL Server Management Studio 2008?

download application from following link

Click here

download “Microsoft SQL Server 2005 Backward Compatibility Components”  

SQLServer2005_BC*.exe or msi according to your machine requirement.

then open SQL Management studio 2008 and double click on DTS. you would be able to open on SSMS 2008.

ssms2008
SQL server Management Studio 2008

 

 

Advertisements

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 )

w

Connecting to %s