Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open a DTS package in "Package Designer" 1

Status
Not open for further replies.

DougP

MIS
Dec 13, 1999
5,985
US
in SQL Server version 7
I found in the Books-on-line a few DTS samples in a zipped file. I unzipped them on the C:Drive. They are files that end in a .dts extension.
How do I load these in the DTS Package Designer to see them?
There is no Load or Open command.
Just Save and Save AS.

TIA DougP, MCP
 
I'm using SQL 2000 so this may not be the same, but I thought I'd see if it helps.

In 2k, if you right click on Data Transformation Service there is an Open option. I use this and it opens the .dts file in designer.
 
right-click the "Data Transformation Services" label in EM, then select Open...
 
Thank you MaxZak
I have to click "All Tasks"
then
"Open Package"
On the DTS part itself
If you are in the view where the DTS pacakges show in the list this option is not available

DougP, MCP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top