June 14, 2014 at 8:29 am
how to load all files in a directory in ssis with different delimiter ?
I have tried this using Foreach File Enumerator. It works fine for same delimiters, but I dont know how to implement it for different delimiters.
June 17, 2014 at 10:22 am
Perhaps a nested ForEach loop container - I'd think about creating a "delimiter" variable, then place a script inside the ForEach task, one that picks up the file, opens it, and looks for the delimiter, assigns it to the variable, then proceeds with processing the file
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 17, 2014 at 1:12 pm
vignesh.ms (6/14/2014)
how to load all files in a directory in ssis with different delimiter ?I have tried this using Foreach File Enumerator. It works fine for same delimiters, but I dont know how to implement it for different delimiters.
You need a seperate data flow for each type of delimiter. Even then, the metadata of the columns needs to be the same.
In the worst case scenario, you need a data flow for each different flat file.
If this is too much work, I advice scripting. You can for example just dump the contents of the flat files in a staging table and split out the data in TSQL and send it to the appropriate table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply