Post reply

SSIS Package and Connection Manager

  • February 24, 2010 at 12:10 pm

    #217260

    I've checked the "Allow saving password" box in the attached Connection Manager module and the "Test Connection" works. However, when I close then reopen the connection, the password wasn't saved, i.e., "*******" doesn't appear in the Password box.

    This is SSIS in SQL Server 2008. Any thoughts?

  • February 24, 2010 at 12:40 pm

    #1124510

    I think this is designed behavior. It still saves the password and it can be used, just doesn't show up in there. I have that with all my packages, drove me nuts for the longest time.


    Shamless self promotion - read my blog http://sirsql.net

  • February 24, 2010 at 12:47 pm

    #1124516

    Are you running the SSIS packages manually or through a SQL Server job?

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

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