Post reply

SSIS and 64 bit

  • September 29, 2009 at 3:29 am

    #211517

    Hi

    I've got an SSIS package to deploy on a 64 bit server. It's giving me the following error:

    DTS_E_CANNOTAQUIRECONNECTIONFROMCONNECTIONMANAGER and failure code 0*C0202009.

    Unfortunately I cannot post the whole error message, as it is in German.

    Any ideas??

  • September 29, 2009 at 8:08 am

    #1059487

    Hi

    If you are loading your package to MSDB and you receive this error when you exucute it. there are two options

    1) Either set a password for whole package it self by going to properties. excrypt all data with password and feed that password under protection level when you load the package.

    2) while loading the package set protection level to "rely on server storage and roles for access control"

    Thanks

  • September 29, 2009 at 8:50 am

    #1059524

    hi

    I tried that and it's not working.

    Thanks for the help anyway.

  • September 29, 2009 at 9:02 am

    #1059536

    I am getting the same error but for a different reason. below as I google has solved that error message for some.

    You may be able to solve this issue by setting Run64BitRunTime property as False

    Go to properties page for the overall SSIS solution, set the Run64BitRunTime = False.

    Or in your case if it is set to False, set it to true. Its worth a minute to change and test.

    Adam

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

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