Import all files in a directory?

Question

Import all files in a directory?

aaa121

SSCertifiable

Points: 5902
More actions
November 27, 2007 at 5:25 am

#119577

Hi All,
I am new to SSIS and I would like to know how you can loop through all files in a directory importing them as you go along?
Thank you

Viewing 4 posts - 1 through 4 (of 4 total)

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

In the toolbox when you have the control flow open you will find a component called a Foreach Loop Container. When you open the edit window for this component you will see that you can configure it to look through all of the files in a specified directory.

aaa121 SSCertifiable Points: 5902 More actions · Answer 2

Wow, I heard it was straightforward. But that, and probably many other things are a vast improvement over DTS!

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 3

It will get a little complicated, but if you search on Google you will find some samples and pictures to walk you through it.

DTS had some good features, but SSIS is a huge step forward.