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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Emergency Help Needed (DTS PACKAGE)

Status
Not open for further replies.

Kenos

Programmer
Jul 21, 2002
28
0
0
US
I have been writing a DTS package using the Eval Version of SQL
The trial period has expired and I cannot install a full version on my Windows Pro System

The Question is:
Can I retrieve the DTS Package from a file to import into my Full Version of SQL?
 
Assuming you used the default storage options for DTS the package is stored in the msdb database.

Its going to be messy to get at. Can you install a full version on some other machine and then attach the msdb database to that install? You don't want to overwrite MSDB on your production database it has all the sql agent jobs etc. in it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top