Link to home
Start Free TrialLog in
Avatar of CRI906
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
ASKER CERTIFIED SOLUTION
Avatar of Jay Toops
Jay Toops
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SoftEng007
SoftEng007

when you click on the package and execute you get the odbc drivers from your workstation.
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?
good point.. i'll bet they arn't
jay
Avatar of CRI906

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.
Avatar of CRI906

ASKER

I'm logged in to the console with the same account that starts the SQLAgent service.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CRI906

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.