Error 0xC0202009 while preparing to load the package

I have an SSIS project that is deployed to a sql server.

The setup of the project is a parent dtsx package, and many child packages.

The parent executes each of the chid packages.

If I run the parent from BIDS, calling the children that are on the SQL Server, it works fine.

If I execute it from SQL Management Console running on my laptop, connected to the SQL Server, It works.

If I remote into the SQL Server and run it from SQL Agent or SQL Management Console, the job fails with the error:

Error 0xC0202009 while preparing to load the package. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x%1!8.8X!.

for each of the children.

This has quite suddenly stopped working, and I cannot figure out why it will work being executed from my laptop, but not on the server.

Any ideas?

Thanks

BobP

When you remote in, are you logging in with the same user/password that you use on your laptop? If not, it is probably a problem with security.|||

Yes I am. That's what is stumping me. Since I am running it from SQL Management Studio logged in as the same user, it should run from both machines.

Thanks

BobP

|||The difference is that for the first two scenarios you listed above, you are likely executing them from your machine. That is, dtexec.exe on your machine is executing the packages. When you remote in, you are using the dtexec.exe on the server. This means that things like network connectivity/firewalls/etc... come into play that might not be on your local machine.

What version of SQL Server do you have installed on your local workstation? Do you have the full SSIS client installed?|||

Hey Phil!

I didn't realize that if i run a sql package, logged into SSIS in SQL Management Console that it ran with the DTExec on my machine. Thanks for that bit of info.

However... Yes, I have the full SSIS installed on my machine, and the versions are:

Server 9.0.3042

Workstation: 9.0.3042

The irritating thing about this is that it started happening after it had been working for 2 months.

And as far as I know, nothing has changed on the server.

BobP

|||

BobP - BIM wrote:

However... Yes, I have the full SSIS installed on my machine, and the versions are:

Server 9.0.3042

Workstation: 9.0.3042

More specifically, Standard, Developer, or Enterprise versions? Also, which is installed on the server?|||

Sever is running enterprise 64 bit

Workstation is running developer.

Thanks!

|||

BobP - BIM wrote:

Sever is running enterprise 64 bit

Workstation is running developer.

Thanks!

Okay, so using this arrangement, when connected to Integration Services, through SSMS, you should be executing the copy on the server. That's my understanding.

Has this package run successfully before on a 64-bit machine? Do you have package logging turned on?|||

Nevermind... After a server re-boot, it is working fine now.

Thanks for all the help!

BobP

Error 0xC0011008 while preparing to load the package

Hello all-

This post is for informational purposes only, as I have solved the issue. However, it was such a sneaky issue that I thought I would share.

I was working from home on a working SSIS package. I deployed via dtutil, and then ran it.

It failed immediatly with the error:

"Error 0xC0011008 while preparing to load the package. Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored."

Nothing on the web helped me.

Well, after about 10 hours of working with it I figured it out.

The first package loaded in SSIS is my parent package, which executes other packages stored in SQL Server.

When I first loaded up the package, my VPN was still connecting. Since I was not on the VPN when this package loaded, it could not validate.

Without any indication, my connection to the SQL Server storing the packages was invalid. All I had to do was open it, and click on OK.

So be aware... If the validation cannot take place, bad things can happen ;-)

Hope this saves someone some time.

BobP

Closing Post.

Error 0x80070002 while preparing to load the package. The system cannot find the file specified

Hi,

I have a package which calls another package. It had been working fine for a while. Recently I changed the connection managers' names. Everything in the parent package works fine. Database has been updated correctly. But when it comes to calling the child package it generates :

OnError,CRPRCHMSQCZ,,Execute AMSClientAgentMaintenance,,,3/8/2007 5:49:38 PM,3/8/2007 5:49:38 PM,-1073602332,0x,Error 0x80070002 while preparing to load the package. The system cannot find the file specified.
. (there is a period here instead of a file name)

I tested the child package on the server. It works fine. I connected the child package to the Execute Package Task by selecting from the packages on the server. So it is there for sure. Connection manager's name is read from the .dtsConfig. Child package is executed from my development machine but not on the server. I made a small test package just to call this child package, it generates the same error...

Any help is appreciated

Gulden

Renaming the connection managers must have corrupted the package.

I restored from the backup and left the connection manager's names as they are.

Error 0x80070002 while preparing to load the package. The system cannot find the file specified

Hi,

I have a package which calls another package. It had been working fine for a while. Recently I changed the connection managers' names. Everything in the parent package works fine. Database has been updated correctly. But when it comes to calling the child package it generates :

OnError,CRPRCHMSQCZ,,Execute AMSClientAgentMaintenance,,,3/8/2007 5:49:38 PM,3/8/2007 5:49:38 PM,-1073602332,0x,Error 0x80070002 while preparing to load the package. The system cannot find the file specified.
. (there is a period here instead of a file name)

I tested the child package on the server. It works fine. I connected the child package to the Execute Package Task by selecting from the packages on the server. So it is there for sure. Connection manager's name is read from the .dtsConfig. Child package is executed from my development machine but not on the server. I made a small test package just to call this child package, it generates the same error...

Any help is appreciated

Gulden

Renaming the connection managers must have corrupted the package.

I restored from the backup and left the connection manager's names as they are.