I've an SSIS package 2005 which uses a for each loop container, this package runs fine when I run it on the local machine .
My server is 64 bit SQL 2005 and I 've successfully deployed my package on the server both to the File system and SQL server. I've also set Run64bitruntime to false in my pacakge. Now I need schedule the package using SQL job. Since Microsoft Jet Provider
4.0 is not available for 64 bit, I had to write script to schedule the package. Here is my script.
'dtexec /sq Package1 /DE 123'
I'm getting the following error when I execute the job.
Could not load package "Package1" because of error 0xC0010014.
Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.
I'm getting the same error if I run this from commandline.
Any help would be really appreciated.
Thanks in advance.
View Complete Post