all groups > sql server dts > may 2005 >
You're in the

sql server dts

group:

Save DTS package with option /F



Save DTS package with option /F TerryMan
5/12/2005 2:25:01 AM
sql server dts: 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?
Re: Save DTS package with option /F Helge C. Rutz
5/12/2005 10:53:57 PM
Hi Terry,

"TerryMan" <TerryMan@discussions.microsoft.com> schrieb im Newsbeitrag
news:3CC1CD67-1A67-4908-8FA9-006A1DEB1CA9@microsoft.com...
[quoted text, click to view]
where is the correlation between DTSRUN and saving the package?

[quoted text, click to view]

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

Re: Save DTS package with option /F TerryMan
5/13/2005 12:31:10 AM
Thanks

[quoted text, click to view]
AddThis Social Bookmark Button