Can anyone tell me the difference between "execute" on a package
versus "dtsrun" command line?

I have a package that runs fine by right clicking and "execute", when
I run from the command line with "dtsrun" it errors out with the
following. This is definitely not a permsissions problem, as I am
logged in as the same account that runs the SQL Agent service.

Error = -2147467259 (80004005) Error string: Specified driver
could not be loaded due to system error 1114 (Alchemy Driver
(*.ald)). Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0

Package uses a 3rd party driver (Alchemy) to transfer data to a SQL
db.

thanks for the help,
Mark

Could this be a profile issue with Alchemy? We've run into similar things
with Brio where the user running the package has Brio set up, but the service
account does not. When the user runs the package - no problems. When the
service tries to run the package it doesn't work because the
registry/path/whatever entries in the profile aren't there.

-Pete

mw243270 (AT) yahoo (DOT) com (Mark) wrote: