October 25, 2013 at 3:16 am
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
October 25, 2013 at 3:23 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply