How to load data from csv file in ssis using for each loop container

Question

Daily SQL Job will start at 12.00. It will run a package that fetch a CSV file from a folder(using for each loop container in ssis). Suppose if there no files in that specific folder. You should not run the package until the csv files load into that folder? How we can do this using SSIS . Please help me on this.

Tab Alleman · Accepted Answer · 2016-05-31 14:02:31Z

1

Have the job run on a schedule. If there are no files in the folder, it won't do anything. The next time it runs, if the files are there, it will process them.

answered May 31, 2016 at 14:02

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

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

Comments

Drishya1 · Accepted Answer · 2016-05-31 16:13:02Z

0

Using a script task, you can check if the file exists in that location with that file extension and then build an expression in the precedence constraint editor. Set the evaluation operation to expression and constraint value to success. Something like the one shown in the screenshot below.

answered May 31, 2016 at 16:13

Drishya1

2692 silver badges4 bronze badges

Collectives™ on Stack Overflow

How to load data from csv file in ssis using for each loop container

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related