"dm4714" <spam@spam.net> wrote
>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?

"Helge C. Rutz" <news050424@nurfuerspam.de> wrote in message
news:3ekc80F3kaeuU1@individual.net...
> Hi dm4714,
>
> I would prefer a real name to address.
>
> "dm4714" <spam@spam.net> wrote
>>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?
>
> 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
>

"dm4714" <spam@spam.net> wrote in message
news:uP5BU6iWFHA.2692@TK2MSFTNGP15.phx.gbl...
> Thanks for the feedback.
>
> I was able to locate
> http://www.nigelrivett.net/DTS/s_LoadPackageToServer.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@nurfuerspam.de> wrote in message
> news:3ekc80F3kaeuU1@individual.net...
>> Hi dm4714,
>>
>> I would prefer a real name to address.
>>
>> "dm4714" <spam@spam.net> wrote
>>>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?
>>
>> 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
>>
>
>

dm4714 wrote:
> Anyone know of a way to force only one version of a DTS package
> within a structured storage file? Currently, I delete the .DTS file in between saving.