August 2, 2006 at 11:47 am
Hi all,
I'm trying to import a few thousand flat files into a few thousand table in an SQL 2005 database.
I've been using Intgration Service's Business Intelligence Development Studio
i have a package that reads all the flat files in a directory using a foreach loop
however i can only figure out how to import all the files into one table,
when i need to have it so each files imports into its own table
does anyone know how i may be able to do this?
it would be greatly appreciated.
thanks in advance
August 7, 2006 at 8:00 am
This was removed by the editor as SPAM
August 9, 2006 at 10:06 am
in your for loop, you could first generate a DDL statement (which creates a specific instance of a table), then execute this DDL, and afterwards import your data into this newly created table.
however, i'd rather have all my data in one table and them run a bunch of selects on this table to get the relevant data out, instead of having to find the right table out of the thousand that i created during the import.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply