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.


1 comment:

  1. Your blog is so cute and I love it. Keep it up.Happy blogging. :)

    www.gofastek.com

    ReplyDelete