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

Dirk usenet at mail-2-me.com
Sat Jan 31 02:09:15 CET 2004


Tim Golden wrote:
>>-----Original Message-----
>>From: usenet at mail-2-me.com [mailto:usenet at mail-2-me.com]
>>Sent: 30 January 2004 12:48
>>To: python-list at python.org
>>Subject: How to start a DTS Package on MS-SQL-Server?
>>
>>
>>Hi!
>>
>>Does anybody know how to start a DTS-Package on a MS-SQL-Server out of
>>a Python-Script?
>>
>>Thanks for your help!
>>
>>Dirk
> 
> 
> Haven't tried it, but there is a dtsrun executable
> (C:\Program Files\Microsoft SQL Server\80\Tools\BINN\dtsrun.EXE)
> in my setup, which seems hopeful.
> 
> There is also a DTS COM library which might do something.
> 
> TJG
> 
> 
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
> 
Hi!

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...).

Dirk



More information about the Python-list mailing list