dynamic column creation for flat fi

Question

I need to load the data into  tables from flat file source. But we do not know flat file contains how many columns (dynamic columns). could you please provide the right way to complete the task.

Answer 1

You then need to create the package programmatically based on a preliminary step of the file metadata discovery output

---

Arthur My Blog

Answer 2

Hi Ramaraju,

SSIS doesn’t support dynamic columns natively. To achieve your goal, you can use a Script Task. The overview of the solution is that read the names and number of columns in the first row of the flat file each time and store it in a variable, then create a staging table dynamically based on this variable, and then use the staging table to load the main table. For the detailed information, please see:
http://www.citagus.com/citagus/blog/importing-from-flat-file-with-dynamic-columns/

Regards,

---

Mike Yin
TechNet Community Support