Dear All, I have to import data from MS Access database using SSIS .and that acces datafile containig password. MS Access database is on different server which in other location. i want to load data on daily basis. how can i do using SSIS. Please suggest the steps Regards, Vipin jhaThankx & regards, Vipin jha MCP

The easiest way to get you started is to use the import/export wizard. Fire it up, configure the load and save the package. Then you can modify the package in BIDS to suit your needs.MCTS, MCITP - Please mark posts as answered where appropriate.

but the problem is that ms access data file is on another server on another location how can i browse thhe feil from SSIS Server. and another thing is that that access file containing password to open the file ? regards, Vipin jhaThankx & regards, Vipin jha MCP

The Access database needs to be on a shared network location, so that the SSIS package on your server can access it. In the import wizard you can specify a username and a password.MCTS, MCITP - Please mark posts as answered where appropriate.

ok , but that access file dont have username only password are required to opne that file Thankx & regards, Vipin jha MCP

when i am loading data from as access to sl getting below error [OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "netXs_AHMEDABAD" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. please suggest ? Thankx & regards, Vipin jha MCP

Dear All, When i am trying to load data from MS Access database to SQL server Using SSIS. I am getting below error. [OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "netXs_AHMEDABAD" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. please suggest regards, Vipin jhaThankx & regards, Vipin jha MCP

Are there any other errors? How did you store the password? Does the Access DB use a .mdw file?MCTS, MCITP - Please mark posts as answered where appropriate.

Dear Vipin The DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error means oftentimes that you run your package in 64 Bit mode whereas no 64 Bit driver esists, thus the remedy is in setting this up: If that does not work, then if you use a configuration check if its getting applied property, and lastly this could be a security issue. Arthur My Blog