dbTalk Databases Forums  

DTS package save

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS package save in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
William Orova
 
Posts: n/a

Default DTS package save - 10-08-2003 , 09:27 AM






HELP HELP
I have been saving my dts packages in structured storage in another file
named dts_production than the server itself. This morning i was asked to
rename on package and it saved itself as a non dts package as a textfile
or whatever so I can not pull it up though EM anymore it says specified
file does not exist but going into the file dts_production I can see it
but it no longer has a dts suffix.. How can I change it back to be a DTS
file

HELP

Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default DTS package save - 10-08-2003 , 10:06 AM







Open Windows Explorer (Disable - Hide File extensions for
known file types)

Select the DTS file and press F2.

Now you can rename the file...Change the Extension
to .dts, the file wld become a DTS File.

Cheers,
Sanka

Quote:
-----Original Message-----
HELP HELP
I have been saving my dts packages in structured storage
in another file
named dts_production than the server itself. This morning
i was asked to
rename on package and it saved itself as a non dts
package as a textfile
or whatever so I can not pull it up though EM anymore it
says specified
file does not exist but going into the file
dts_production I can see it
but it no longer has a dts suffix.. How can I change it
back to be a DTS
file

HELP

Bill

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.