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?