I have a .dts file that I would like to open/setup within my SQL Server 2000
server.

Does anyone know of a way I can insert the DTS package without using
Enterprise Manager?

I'm trying to automate via Inno Setup and can use OSQL.

I think, EPM is the only way to add dts packages

Hi dm4714,

I would prefer a real name to address.

"dm4714" <spam (AT) spam (DOT) net> wrote
You can insert dts files with the COM API of DTS. So you have to write a
simple programm to open the file and write the content to the SQL Server.
You only need the LoadFromStorageFile and SaveToSQLServer methods.
Or you search for free tools doing this for you in the internet.

But there is one limitation - using the API you will lose the formating of
the package and all steps will be graphicaly rearranged.
The EM/Designer is the only way to load with format.

Helge

Thanks for the feedback.

I was able to locate
http://www.nigelrivett.net/DTS/s_Loa...eToServer.html -- which works
fine. But I do have another issue with this...

It would appear the I have to have the .dts file located on the SQL Server
machine instead of locally wherever I'm trying to execute the SP from. Is
there another way or am I doing something wrong?

Basically, I'm trying to have a SETUP program install the DTS package from a
client PC. So both SQL and the .dts file are not on the same box.

There has to be a way to do this as using Enterprise Manager locally on the
user's box allows for me to open and save a package remotely.





"Helge C. Rutz" <news050424 (AT) nurfuerspam (DOT) de> wrote

Nevermind - I rewrote this as a VBScript so it can be run locally on the
workstation instead of objects instantiated via SP on Server.



"dm4714" <spam (AT) spam (DOT) net> wrote

Anyone know of a way to force only one version of a DTS package within a
structured storage file? My problem is, when I make changes to the DTS
package, my script won't insert it since I have to tell it which version of
add. Currently, I delete the .DTS file in between saving.

dm4714 wrote:
That's the only way I know.
Another solution could be to get the list of packages in the file with GetSavedPackageInfos, check for the latest version then load
and execute that one.

Helge