Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deepakugale
Starting Member
33 Posts |
 Posted - 2010-03-02 : 00:20:09
|
| Hi All ,I am very new to SSIS ,can anyone please guide me ,How to import Microsoft Access database file (.mdb) to Sql Server 2005.Thanks Deepak |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-02 : 00:49:04
|
| if it's a one time shot, just use the data import wizard.you can save the ssis package it generates and examine it as well, or schedule it to run periodically if it needs to be a recurring job |
 |
|
|
deepakugale
Starting Member
33 Posts |
Posted - 2010-03-02 : 01:14:18
|
| NO ,it's not just one time shot,I have to make package with the use of SSIS,so that i can import any MDB file send by my client to SQl server,And my clients old system uses access db,so to compare old data with new one,which is in sql server,i have to import that .mdb file in sql server . |
|
|
|
|
|
|
Import MDB