I ran this as sysadmin from qa using xp_cmdshell and got

DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)

Error string: ...

ALZDBA, thanks for looking at this.

I'm new to DTS and Stored Procedures. And I was having a hard time finding a best practices with details on implementation.

I only want...