(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

I 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 (AT) comcast (DOT) net> wrote