Importing data from MS Acces to Sql server database using SSIS
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
June 29th, 2012 2:49am
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.
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2012 2:57am
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
June 29th, 2012 2:59am
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.
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2012 3:01am
ok ,
but that access file dont have username only password are required to opne that file
Thankx & regards, Vipin jha MCP
June 29th, 2012 3:23am
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
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2012 4:40am
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.
June 29th, 2012 6:58am