[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Auto Import Flat Files SQL2005 SSIS?

Posted on 2008-11-13
2
Medium Priority
?
357 Views
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?
0
Comment
Question by:DLHamblin
2 Comments
 
LVL 22

Accepted Solution

by:
PedroCGD earned 1000 total points
ID: 22950204
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
 

Author Closing Comment

by:DLHamblin
ID: 31516363
Wow, Yes excatly what I was looking for.  You have been very helpful!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

873 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