dbTalk Databases Forums  

Save DTS package with option /F

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


Discuss Save DTS package with option /F in the microsoft.public.sqlserver.dts forum.



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

Default Save DTS package with option /F - 05-12-2005 , 04:25 AM






I would like to save the definition of a DTS on a file.
Besides I would like overwrite the file every time that the DTSRUN is
performed, so that to contain the dimension of the file that grows always
otherwise.
Can you help me?
Thanks

Reply With Quote
  #2  
Old   
Helge C. Rutz
 
Posts: n/a

Default Re: Save DTS package with option /F - 05-12-2005 , 03:53 PM






Hi Terry,

"TerryMan" <TerryMan (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:3CC1CD67-1A67-4908-8FA9-006A1DEB1CA9 (AT) microsoft (DOT) com...
Quote:
I would like to save the definition of a DTS on a file.
Besides I would like overwrite the file every time that the DTSRUN is
where is the correlation between DTSRUN and saving the package?

Quote:
performed, so that to contain the dimension of the file that grows always
otherwise.
There is no overwrite feature vor DTS files, the append is automaticly as
long the file already exist.
But in Designer you can workaround this easily by selecting save as instead
of save.
In the dialog box you then press the browse button, in file browse dialog
select the existing file and press Shift-Del, then press the save button,
then OK, and you replaced the file :-)

Helge




Reply With Quote
  #3  
Old   
TerryMan
 
Posts: n/a

Default Re: Save DTS package with option /F - 05-13-2005 , 02:31 AM



Thanks

"Helge C. Rutz" wrote:

Quote:
Hi Terry,

"TerryMan" <TerryMan (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:3CC1CD67-1A67-4908-8FA9-006A1DEB1CA9 (AT) microsoft (DOT) com...
I would like to save the definition of a DTS on a file.
Besides I would like overwrite the file every time that the DTSRUN is
where is the correlation between DTSRUN and saving the package?

performed, so that to contain the dimension of the file that grows always
otherwise.

There is no overwrite feature vor DTS files, the append is automaticly as
long the file already exist.
But in Designer you can workaround this easily by selecting save as instead
of save.
In the dialog box you then press the browse button, in file browse dialog
select the existing file and press Shift-Del, then press the save button,
then OK, and you replaced the file :-)

Helge




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.