I'm trying to input a few thousand flat files into a few thousand tables in a sql database, using SQL Server Business Intelligence Development Studio.
im using a for each loop to read all the files in a directory
the problem is i can only insert the data from all the files into one table
does anyone know a way to do multiple tables? maybe using some sort of variable?
Use the multicast in the dataflow.
Kirk Haselden
Author "SQL Server Integration Services"
No comments:
Post a Comment