I do not know the best place for this question.
Problem: I have multiple txt files in different formats as they come from different sources. I need to load this data into a single table. Since the files are being generated from multiple sources the data needs some massaging before it is loaded. We are currently loading the data all with dynamic sql. Though this works it limits the amount of control/visibility/performance we have while processing the data. I would like to use SSIS for this, but have found this to be difficult as most tasks are expecting static meta data. I was wondering if anyone has come across this and has found a way of doing this? Just a note I have a limited C# background so I am trying to accomplish this without using script tasks. Any advise/ideas would be much appreciated.