yanci1179
asked on
SSIS package running on Task Scheduler
When running my ssis package on task scheduler I am getting a script task error. (In case anyone is wondering, DBA's don't let us use SQLServer Agent.)
When I run a bat file to call the package, which is calling it fine, I get the following error:
"ScriptTask_GetAccessDBSch ema:Error: Exception has been thrown by the target of an invocation."
The package runs fine locally. I also placed the package under 'False' Run64BitRuntime.
any Ideas?
When I run a bat file to call the package, which is calling it fine, I get the following error:
"ScriptTask_GetAccessDBSch
The package runs fine locally. I also placed the package under 'False' Run64BitRuntime.
any Ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.