DTS: Problems using DTSRUN but okay in Designer.

(SQL Server 2000, SP3a)
Hello all!
I've got a package that contains other sub-packages. The "outer" package that I'm trying
to execute has a bunch of Global Variables (GVs) that control the Source and Destination
server/database/credential information. The "outer" package doesn't really do anything
with these GVs except to pass them into the sub-packages, and those are responsible for
connecting to the various servers and "doing their thing".
When I load my outer package for the first time (it's a structured storage file) and use
the Designer to assign the values to the GVs and run it, everything works fine. However,
when I try to do similarly with DTSRUN, I get an odd error:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_MyPackage
DTSRun OnError: DTSStep_DTSExecutePackageTask_MyPackage, Error = -2147467259 (80004005)
Error string: DTSStep_DTSExecuteSQLTask_1: Invalid authorization specification
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
I'm not sure why I would be getting this "Invalid authorization specification" error,
unless DTSRUN is having a hard time transferring the GVs from the "outer" package to the
"inner" package?
Any help would be greatly appreciated. Thanks!
John PetersonI finally put some rudimentary logging in the package to spit out the GVs. Turns out,
when I was invoking the package for DTSRUN, I was defining the GVs:
SourceLogin
DestinationLogin
And my package was expecting:
SourceUser
DestinationUser
Go figure! :-)
Once I fixed that, all was well.
Thanks for your help!
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23qJbvrzUEHA.1152@.TK2MSFTNGP09.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> I've got a package that contains other sub-packages. The "outer" package that I'm
trying
> to execute has a bunch of Global Variables (GVs) that control the Source and Destination
> server/database/credential information. The "outer" package doesn't really do anything
> with these GVs except to pass them into the sub-packages, and those are responsible for
> connecting to the various servers and "doing their thing".
> When I load my outer package for the first time (it's a structured storage file) and use
> the Designer to assign the values to the GVs and run it, everything works fine.
However,
> when I try to do similarly with DTSRUN, I get an odd error:
> DTSRun: Loading...
> DTSRun: Executing...
> DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
> DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
> DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> DTSRun OnStart: DTSStep_DTSExecutePackageTask_MyPackage
> DTSRun OnError: DTSStep_DTSExecutePackageTask_MyPackage, Error = -2147467259 (80004005)
> Error string: DTSStep_DTSExecuteSQLTask_1: Invalid authorization specification
> Error source: Microsoft OLE DB Provider for SQL Server
> Help file:
> Help context: 0
> I'm not sure why I would be getting this "Invalid authorization specification" error,
> unless DTSRUN is having a hard time transferring the GVs from the "outer" package to the
> "inner" package?
> Any help would be greatly appreciated. Thanks!
> John Peterson
>