Auto Import Flat Files SQL2005 SSIS?

Posted on 2008-11-13
Last Modified: 2013-11-10
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?
Question by:DLHamblin
    LVL 22

    Accepted Solution

    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:

    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:



    Author Closing Comment

    Wow, Yes excatly what I was looking for.  You have been very helpful!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now