Loading data from multiple files

[groleau]

I'm still waiting for SQL Server 2005, but I'm starting to build my package in Visual Studio.

I'm wondering how I should choose between using a ForEach container to loop over all the input files or using a "Multiple Flat Files" connection manager.

Files are CSV with field names on first row.

I have to load a year's historical data. After I do that and create the logic to produce reports, a secretary will be doing the updates as new data is e-mailed to her each week.

I'm hoping I can provide a way she can just drag all the file icons (five or six at a time) from the e-mail attachments panel directly onto the desktop icon for a Windows application.

--
Wes Groleau

http://www.Parkview.com/

 

[groleau]

I should have put this query in another forum. It's really more of a studio question.

In fact, I got a couple of answers there:

http://www.tek-tips.com/viewthread.cfm?qid=1375011&page=1

Not exactly what I wanted, but you got to live with what's possible.

--
Wes Groleau

http://www.Parkview.com/