To remove this error double click your new connection in the Connection Managers.
Move to the 'All' tab.
Enter the password against the propery "Jet OLEDB:Database Password".
And Test Connection. Success.
Thursday, February 11, 2010
Password Protected Access DB and SSIS
Today I shall show you how to import data using SSIS from MS Access 2007 which is password protected. Creating a connection using Access provider and now specifying password would give error:
To remove this error double click your new connection in the Connection Managers.
Move to the 'All' tab.
Enter the password against the propery "Jet OLEDB:Database Password".
And Test Connection. Success.
To remove this error double click your new connection in the Connection Managers.
Move to the 'All' tab.
Enter the password against the propery "Jet OLEDB:Database Password".
And Test Connection. Success.
Subscribe to:
Post Comments (Atom)
Your blog is so cute and I love it. Keep it up.Happy blogging. :)
ReplyDeletewww.gofastek.com