Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question about flat file source connection in DTS packages Expand / Collapse
Author
Message
Posted Friday, October 25, 2013 3:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:14 AM
Points: 338, Visits: 954
Hello all,

So I've been tasked with doing a total conversion of the main bulk of dts packages that run at our clients warehouse systems to ssis. This is because A)all the databases are being switched over to sql server 2008 B)the software lisence on a previous system has run out

So yesterday I converted 7 packages which all follow the same logic,take a csv file and load it into the database.
However I can't tell from the DTS package itself whether the flat file source runs for a single file or if multiple are possible.

So can anyone tell me what is correct,I got a flat file connection that points to a folder can multiple files exist or is only 1 read
Post #1508374
Posted Friday, October 25, 2013 3:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
It will only read the flat file with the name configured in the flat file connection manager.
Since all files in a folder have unique names, you read only 1 file.

In order to read multiple files, you need to use a for each loop and set an expression on the flat file connection manager.

Looping over files with the Foreach Loop

There's also the multi flat file connection manager. I've never used it, but I've read some blogs who suggest to avoid it.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1508376
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse