Post reply

Error while deploying SSIS package

  • October 22, 2008 at 10:17 pm

    #124106

    hi

    while deploying SSIS package from server A to server B

    i m getting following error

    -----------------------------------------------------------------------------

    Error1

    Error loading SSIS_DataDump_Event.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B

    "Key not valid for use in specified state.".

    You may not be authorized to access this information.

    This error occurs when there is a cryptographic error.

    Verify that the correct key is available.

    T:\REPORT\DataDump\SetUp\SSIS_DataDump_Event.dtsx11

    -----------------------------------------------------------------------------------

    Please Help me

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 23, 2008 at 1:26 am

    #888485

    post this item in the Integration Services and you'll get more response hopefully.

    I know you can set security in SSIS packages on several levels and configuration of the packages can be done in the database or an XML file. Maybe its get you into an direction.

    ------------------------------------------------------------
    Application Architect and Developer @ Traffic4u
    Visit my profile on LinkedIN

Viewing 2 posts - 1 through 1 (of 1 total)

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