SSIS Package Fails Immediately in Data Manager

[Former Member]

Hey all!

I have an SSIS Package that works perfectly in my Production system. I'm currently trying to test the exact same package in my Test System. The only change I've made to the package was to change the server name to point to our Test Server.

Now, within SSIS, this Test package runs completely fine. However, when I try to run the exact same package through the Data Manager. The package Errors out immediately. Of course, BPC gives no error message at all to help troubleshoot.

Does anyone have any idea why this package would work on our Production system, but not our Test Server? Any hints on what to look for would be extremely welcome!

Thanks much!

Sean

[Former Member · Accepted solution]

For clarity, you have an SSIS package in production, in the DM file folders, that you are copying over to a file location in the TEST environment. Then you are adding the package via the DM interface. The saving the view. Then trying to execute the package?

-If you edit the package via the DM interface, does everything look correct, regarding settings for the package?

-Does the package have more SSIS tasks than just standard BPC tasks? Do they need to be modified for the new servers.

- WHat does the package do? Is it supposed to run logic? B/c it may need the logic statements to be validated and saved?

Please Let us know.

[Former Member · Accepted solution]

Thanks Petar!

Your questions actually made me realize what the problem was. I was testing a "Test" Version of the same package that was in production. When I copied the actual production package onto the Test Machine, I was able to process successfully.

The problem I was having with the original package was due to a password not being set properly on the "Test" package. Once I set the password, everything ran fine.

Thanks for prodding my brain along...

Sean

[Former Member]

P.S. We're running BPC 5.1 SP3.