How to start a DTS Package on MS-SQL-Server?

Sat Jan 31 03:09:08 EST 2004

Dirk <usenet at mail-2-me.com> pisze:

> Sorry, I think I forgot to write that I want to start this from a remote 
> computer. So I can't simply use popen. But I know about this dtsrun 
> executable (that's how the sql-server does it itself...).

This can be painful... Try to schedule your package and look at
"Operating system comand" field in scheduled job properties. You will
get the idea on how packages are run by dtsrun.exe.

The other idea worth exploring is "MS OLE DB Provider for DTS Packages"
-- loosely documented component of any contemporary (>2.5) MDAC package.
When I needed to run packages from my program, I had no time to dig in
MSDN, so I cann't say anything more.

-- 
Jarek Zgoda
Unregistered Linux User #-1
http://www.zgoda.biz/ JID:zgoda-a-chrome.pl http://zgoda.jogger.pl/