Post reply

SSIS package Corruption Error !!!

  • May 27, 2008 at 10:43 pm

    #207756

    Hi pals,

    We have developed few SSIS Packages at client environment using BIDS tool.

    We normally connect to the client environment using a VPN.

    To replicate the work at our local end, we copied the XML Config files and SSIS packages to our local end.

    At local end , we changed the connection manager information in xml files and tried to open the package in the BIDS. While opening we are encountering the below error msg.

    "There were errors while the package was being loaded

    The package might be corrupted.

    See the Error List for details "

    What could be the reason for this?

    If i want to replicate the same work at different environments what need to be done.

    Any suggestions would be greatly appreciated.

    Thanks in advance.

  • May 28, 2008 at 6:02 am

    #821113

    You can get this message for a lot of reasons. You need to get the specific error messages from the error message list to determine what is wrong. My guess is that the package encryption was set to encrypt with user key (the default) and you have opened it with a different windows login than the one it was created with. This just wipes out passwords in connection strings and is probably not an issue for you.

  • May 28, 2008 at 9:59 pm

    #821569

    Hi Micheal,

    Thanks for the responese.

    But if i want to open the copied packages at local environment what need to be done? is there any to turn off the default encryption level?

    Thanks!

  • May 29, 2008 at 5:12 am

    #821678

    Change the encryption to DontSaveSensitive or EncryptSensitiveWithPassword - these options do not depend on the NT Login.

  • May 30, 2008 at 3:16 am

    #822165

    Thanks Micheal!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply