Skip to Content
author's profile photo Former Member
Former Member

SSIS Package Fails Immediately in Data Manager

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 10:25 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 08:12 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.