manual execute vs. dtsrun
Posted on 2004-09-24
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,