Importing multiple files

Last Post 20 Jun 2012 07:24 AM by dbandee. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
dbandee
New Member
New Member

--
15 Jun 2012 01:01 PM
Hi
I need to import 20 files into 20 diff tables
I am not sure how to do it.

All tutorials i saw onine talk aobut imprting multiple files, that have the same structure into one table.
But how do i do it into many tables.
There always be same 20 files aonce a month going to 20 tables.

What i trying to avoid is to be creating 20 data soiurces and 20 destinatins etc.
Is there an easy way?

thanks

gunneyk
New Member
New Member

--
18 Jun 2012 11:23 AM
If they are different tables you will need different packages or at least different tasks and they will need their own source and destination as they are all different. The good news is you only have to do it once for each table. YOu can use the import wizard to quickly create a package that you can start with.
dbandee
New Member
New Member

--
20 Jun 2012 07:24 AM
Thank you


Acceptable Use Policy
---