• It sounds like you may have your SSIS package protection level set to "Don't Save Sensitive", which will not store any passwords and will prompt each time. You should set this to some other selection - most would recommend "Encrypt Sensitive with Password".

    See the following discussion for more info:

    http://www.sqlservercentral.com/Forums/Topic592450-148-1.aspx

    hth,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices