I need your help in building a ssis package to load 80 different flat files (.txt files) from a single folder location to different tables on sql server.
I did some research online and found that, using for each loop this can be possible. But I would need help with a step by step process. Please help!
Please let me know if my question is not clear.