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