Hi,

I'm trying to import some .mdb files into sql server. Those files are the
same but comes from different companies.

After i import the mdb files, i append them to a normalized tablestructure
where i update an empty field which is the name of the company where the
database comes from.

Now i know that i could do this automatically, but i don't know if i should
a stored procedure for this or a local package. In a stored procedure i
could use the temp database of sql server to save the import temporarly.

Could i have some advice on this subject?

Why would you use TempDB?

If the structures are the same then do this

Create a package that imports 1 of those MDBs
Create a controller package which in it has a loop routine over the
directory in which you hold the mdbs
In each loop you call the MDB package. You pass in to that package the
name of the MDB and it sets the Access connection accordingly.
You could also pass in the name of the company from which you got the mdb.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Samuel" <samuel (AT) hotrmail (DOT) com> wrote