Looping over files with the Foreach Loop and loading to diffrent ...

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Praxy Mr or Mrs. 500 Points: 573 More actions · Answer 1

This was solution posted by weehyong..

thanks to u ..

Assuming the following

- All the CSV files are of the same format (assuming your files are table_1.csv, table_2.csv, ...)

- All the 10 tables you are writing to are of the same format

You can do the following:

This will load table_1.csv to table_1, table_2.csv to table_2, etc.

Create a package scope variable

- CSVFileName, (String)

- Remember to set it's value to any value (or the name of the first table you want to insert into)

Create a Foreach Loop Container

Enumerator: Foreach File Enumerator

Folder: Retrieve file name: Name only (this will give you only table_1)

Variable Mappings

Map User::CSVFileName to Index 0

Add a Data Flow Task in the Foreach Loop Container

Consists of

Flat File Source and an OLE DB Destination

Two Connection Managers (Flat File Source, and OLE DB Destination)

For the connection manager, Flat File Source

Click Expressions

Choose the ConnectionString property

Use the expression:

" " + @[User::CSVFileName] + ".csv"

For the OLE DB Destination

Select Data Access Mode: Table name or view name variable

In the Variable Name, select User::CSVFileName

chukliz Grasshopper Points: 11 More actions · Answer 2

Hello,

Please I am having same problem. I was wondering if this solution resolved the initial problem.

I need help on how to resolve this problem because I am facing the same issue.

Thanks