none
Bug in SSIS - Cannot save oledb connection passwords no matter what

All replies

  • Quite possibly you have already looked into the package level property that says "Do not save sensitive". But just reminding.

    - Aalam | (Blog)

    Saturday, November 09, 2013 12:57 AM
  • Quite possibly you have already looked into the package level property that says "Do not save sensitive". But just reminding.

    - Aalam | (Blog)

    I tried dont save and encrypt sensitive. It all fails. This connection problem has been a major issue in all my work. I used to enter passwords for my package and things would work. Now the same old stuff is not working. SSIS works fine only in toy examples and youtube videos. Try using it in an enterprise environment and see what happens.

    Saturday, November 09, 2013 6:23 PM
  • Are you using configurations besides "Do not save sensitive"? Otherwise your package won't have any passwords in it...

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Sunday, November 10, 2013 2:06 PM
    Moderator
  • I tried dont save and encrypt sensitive. It all fails. This connection problem has been a major issue in all my work. I used to enter passwords for my package and things would work. Now the same old stuff is not working. SSIS works fine only in toy examples and youtube videos. Try using it in an enterprise environment and see what happens.

    Do not blame your inexperience on the platform. The platform is rock solid and it is used primarily in enterprise environments.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Sunday, November 10, 2013 6:14 PM
  • I tried dont save and encrypt sensitive. It all fails. This connection problem has been a major issue in all my work. I used to enter passwords for my package and things would work. Now the same old stuff is not working. SSIS works fine only in toy examples and youtube videos. Try using it in an enterprise environment and see what happens.

    Do not blame your inexperience on the platform. The platform is rock solid and it is used primarily in enterprise environments.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Okay, I will admit that I am inexperienced. But, why do these connection problems keep happening ? I have face this situations twice and it this time its very difficult to figure out the reason.  Can you suggest something to fix this problem ?

    Thanks.
    • Edited by blastoSO Monday, November 11, 2013 2:52 AM
    Monday, November 11, 2013 2:50 AM
  • I think your current package is corrupt.

    I would suggest you start with a brand new clean package. Setup the simplest first step and make sure it works. Then start gradually adding more and more elements from your original package. Eventually you will be able to find what breaks your package. Post back your results.


    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Monday, November 11, 2013 3:10 AM
  • Not sure how are "transactions" related to your originally reported issue related to saving passwords. But glad that you've been able to sort it out and marked your thread as answered.

    - Aalam | (Blog)

    Tuesday, November 12, 2013 3:20 AM
  • Not sure how are "transactions" related to your originally reported issue related to saving passwords. But glad that you've been able to sort it out and marked your thread as answered.

    - Aalam | (Blog)

    oh yes, it is related to the link and not this question. 
    Tuesday, November 12, 2013 6:15 AM