I need to take one CSV file and import it into multiple tables in a database. What I'm not sure of how to do is specify which table the data should go into. I have successfully imported into one, but not sure how to do multiple tables. Just a point in a general direction or documentation would be helpful!
Thanks,
Brian

Number of ways to do this. Is this a Master:etail import but the details
are all in one file and you want to split it?

Personally I would

1. Import the file into a staging table as is.
2. Run over the data and import the master rows
2. Run over the data again and join the Master table to our staging table
and import the detail rows.

You can do this in one pass using lookups but you will suffer on performance

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"BMoritz" <BMoritz (AT) discussions (DOT) microsoft.com> wrote

should go into. I have successfully imported into one, but not sure how to
do multiple tables. Just a point in a general direction or documentation
would be helpful!

So you have 2 * tables

RetailCustomer and SalesCustomer.

I won't go into how this would on the face of it seem to be a bad design but
here we go with a solution

1. Should I have each table in a seperate file?

Perhaps. Can you identify easily what is what? If ==yes then you can still
import into a staging table on the SQL Server and then use TSQL

Does the file contain the same data for both types of customer? If it does
then this serves to illustrate my point that you should only have one
Customers table with a flag for "Retail" or "Sales"

Splitting your source files into their respective destination tables would
be easy as well.



--
--

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


"BMoritz" <BMoritz (AT) discussions (DOT) microsoft.com> wrote

customer. Each of those (wholesale customer and a retail customer) are a
table in my DB, and within that table is name, address, phone number, etc. I
need to have that CSV file import the data of the name, address, phone into
the corresponding tables. Is it better to have each table in a separate CSV?
This process will be set and done by a user, not an automated interval.