CRI906
asked on
manual execute vs. dtsrun
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
good point.. i'll bet they arn't
jay
jay
ASKER
I'm logged in to the console of the server machine and running both Enterprise Manager and the command line DTSRUN.
check to see what user sql agent is using.
I believe dtsrun will use those permissions.
enterprise manager will use the permissions of the user.
I believe dtsrun will use those permissions.
enterprise manager will use the permissions of the user.
ASKER
I'm logged in to the console with the same account that starts the SQLAgent service.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, path variables have the same values. I am able to reproduce this error on another SQL box as well.
I'm perplexed. Thanks for the effort.
I'm perplexed. Thanks for the effort.
when you use dtsrun you get the odbc drivers from the server you run the package on.
Are you sure the drivers are installed and working on your server?