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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Import Multiple MDBs with SSIS package

Author  Topic  GeekZ Starting Member 1 Post Posted - 2008-07-24 : 15:47:58 Hello, I am new to SQL Server 2005 and have created an SSIS package to import 12 separate Access MDB's into SQL Server. Each MDB contains one month of activity and each MDB has identical columns/fields. I need to import all 12 months into one large table in SQL Server. Thus, I need to loop through each of the MDB's in the SSIS package and append into one Table in SQL Server. The problem is, that my package loops through 12 times, but just continually loops through the first MDB, thus I am getting one big table that consists of Month 1 multiplied 12 times? How can I get my package to loop through EACH separate MDB and append into the one table? Any help would be most appreciated. Thanks!