*ETL_Status is a tempory table, for the duration of the procedure, to extend it beyond that use ##ETL_Status, or a permanent table.

Thank Johnson, sorry for cryptic but have to run.

Dave

Once scripted, from Query Analyzer, run

DI_ExecuteDTS

   @server varchar(255),              --- Required: SQL Server name

   @PkgName varchar(255),           --- Required: Package Name

                                                ---(Defaults to most recent version)

   @ServerPWD varchar(255) = Null, --- Optional:...

Hi

Please be aware: the script is as is, and developed from a bit of Google research...where applicable thank you to the original authors.

Copy and paste:

if exists (select * from...

Hi, I have a sp that will launch a DTS package, query the result and return errors/success.

It converts hex error value to char message, and returns all info (you can...

Hi, I'm baffled..

following the above examples, I created a package and it executes fine from .Net

However, within the packages, there are active x tasks...

The other option for remote server execution is to execute package as Job, with sp_add_job, sp_add_jobserver, sp_add_jobstep

Dave