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 |
|
ronedin
Starting Member
29 Posts |
 Posted - 2007-10-17 : 22:53:13
|
| Hello,I have 2 tables EmployeeA(Eng) and EmployeeB(Spanish) kept in seperate mdb's. I want to add the records into Sql Server 2005 table called StateEmployee.Procedure:1. Loop through 2 folders..one containing table EmployeeA in mdb and other containing tbl EmployeeB in diff mdb's.2. Pick a file from EmployeeA and EmployeeB, both at the same time.3. Count the total no of rows in both files. If equal proceed.4. Compare the 'employeeid' of one row of employeeA to the employeeid of EmployeeB.5. If employee id matches, load both the rows in Sql server else file it to the error table.6. Loop through all rows simultaneously till end of row.7. Go to next mdb.How do i go about this step by step. I am fairly new to SSIS. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-10-18 : 06:46:28
|
| What have you come up with so far? So to clarify, are you looping through a directory storing multiple Access DBs?Mark |
 |
|
|
|
|
|
Read data from two files simultaneously