Managing DTS Programmatically

6 Jan 2006 6:16 PM

rmg66

Does anyone out there have any tip on managing DTS packages
programmatically?

Specifically, I want to install and run a dts package using tsql through
query anyalyzer.

I know how to run it using the xp_cmdshell, but I don't know how to install
it programatically from a Structured Storage File.

6 Jan 2006 7:15 PM

Dan Guzman

You can 'install' the structured storage file like you would any other file
needed by your application. DTS doesn't really care where the file resides.

You might consider creating a folder on the SQL Server specifically for DTS
package files. You could then launch the packages using DTSRUN via
xp_cmdshell from that well-known location. Folder/file creation can be done
manually or as part of a Windows Installer package, depending on your
deployment requirements.

--
Hope this helps.

Dan Guzman
SQL Server MVP

Show quote

"rmg66" <rgwathney__xXx__primepro.com> wrote in message
news:%23WYn30uEGHA.524@TK2MSFTNGP09.phx.gbl...
> Does anyone out there have any tip on managing DTS packages
> programmatically?
>
> Specifically, I want to install and run a dts package using tsql through
> query anyalyzer.
>
> I know how to run it using the xp_cmdshell, but I don't know how to
> install
> it programatically from a Structured Storage File.
>
>

20 Mar 2006 3:08 PM

Enric

you might read something about dtspkg.dll on the web

--
current location: alicante (es)

Show quote

"rmg66" wrote:

> Does anyone out there have any tip on managing DTS packages
> programmatically?
>
> Specifically, I want to install and run a dts package using tsql through
> query anyalyzer.
>
> I know how to run it using the xp_cmdshell, but I don't know how to install
> it programatically from a Structured Storage File.
>
>
>