FreeTDS Development Group

["ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>]

> 
> Hi!
> 
> I am looking for a way to activate Data Transformation 
> Services (DTS)  
> via PHP (using freetds).
> Is there a way to do this?
> 
> Any help or hints would be really appreciated.
> 
> 
> Thanks for your help in advance,
> 
> Sven
> 

DTS are just some type of scripts recorded in database (I don't know
where and how) executed with some tools (ActiveX or DTSRun program), so
you need a windows machine to execute them. If you schedule a DTS you
can read DTSRun command line and execute it on a sql server machine with
xp_cmdshell from your PHP script (or if your PHP script reside on a
windows machine execute DTS directly)

freddy77