Create Tables Dynamically from Flat Files and load Data using SSIS package Problem statement: You received flat files or text files or csv files in one of the source folder. You need to write an SSIS ...

To save more than 255 characters to Excel file in SSIS, don’t use Excel Destination. It won't work except a few edge cases. Instead, use combination of SQL Script Task + Script Task: The general idea ...