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.