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 |
|
Zack
Starting Member
26 Posts |
 Posted - 2008-06-04 : 08:12:06
|
| Greetings,I have zero expereince with SSIS so I'm not sure if it is the right tool for the task or not. Here's the secenario:Quarterly we receive CDs with data that's stored in MS Access databases. The current process is to import each CD of data into separate tables. I'm proposing that we import the data from each CD into a single table. One problem I have identified is there are duplicate values in some of the tables. Can SSIS import data from mulitple sources and remove duplicates?If SSIS isn't the way to go what approach would you recommend? Thanks in advance for your replies/advice. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 08:23:55
|
| Yup you can use SSIS to import from several source and rempve duplicates also. How will you data exists in CDs? As flat files? |
 |
|
|
Zack
Starting Member
26 Posts |
Posted - 2008-06-04 : 08:30:20
|
| Thanks for the quick reply. The data on CDs is stored in MS Access database files so I'll be importing from Access into SQL Server 2005 tables. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 13:24:43
|
quote:
Originally posted by Zack
Thanks for the quick reply. The data on CDs is stored in MS Access database files so I'll be importing from Access into SQL Server 2005 tables.
Ok you just need to use an access connection manger as your source connection and OLEDB destination as your destination connection. |
|
|
|
|
|
|
Is SSIS the way to go?