Auto Import Flat Files SQL2005 SSIS?

We will be using a product called WebFocus to creat business system reports for users.  It will collect data from various sources into a SQL 2005 database.  The plan is to have triggers on the other systems db (Progress 9.1C) to write transactions out to a flat file to be imported into the SQL 2005 DB.  I am in the process of getting up to speed on SQL2005 (we have used SQL2000 up to now), and I believe SSIS in SQL 2005 will do nicely, but I haven't gotten up tp speed enough to answer this initial question:
Can SSIS be setup to look at a directory and automatically import these flat files in when they show up?

Ideally we would like to have it so as the other system creates the files and puts them in a directory, the SQL2005 automatically pulls them.

Will SSIS do this or will I need some other product?
DLHamblinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PedroCGDCommented:
1. You can create a SSIS package to look for files in a directory using For Each Loop.
See and download the package I made here:
http://www.experts-exchange.com/Microsoft/Applications/Q_23862646.html

2. Then you can use a SQL Job to execute eah minute or for example use the konesans control that do it for you... See and download the packahe I made here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23760197.html

helped?
regards!
Pedro

www.pedrocgd.blogspot.com

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DLHamblinAuthor Commented:
Wow, Yes excatly what I was looking for.  You have been very helpful!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.