How to using the loop and bulk load tasks to insert the name of the csv files being looped?

Question

Description

I have created an SSIS package imports data from hundreds of csv files on a daily bases
I have used the bulk load and foreach loop container

Problem

I have created a column on a database table and wanted to know if it is possible to add the source file name on each row of data.

HLGEM · Accepted Answer · 2010-07-30 16:59:32Z

1

If you have the filename in a variable (which you could do in the for each loop) then you just use the variable as the data source for the column. Or ther may be a system variable that contains the file name, pole around a bit inthe system varaibles available to you and see.

answered Jul 30, 2010 at 16:59

HLGEM

97k15 gold badges120 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to using the loop and bulk load tasks to insert the name of the csv files being looped?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related