Insert the data to a MSSQL tables from files without header using Dynamic Schema

[shikhardwivedi]

Hi,

I have a scenario where I have multiple delimited flat files with no header in it. All these files will have a different structure. I have to create one job to read the files and insert the data to an MS SQL table. 

This job will be used for multiple files so the schema should be read dynamically and the data will be inserted to the respective tables.

I tried reading the schema of the target table and set it to the input flat file using tSetDynamicSchema but tSetDynamicSchema doesn't work with tFileInputDelimited.

I have also tried to create the INSERT INTO TABLE query by reading the delimited file row by row and using this query in the tDBRow component and it worked but this job is too slow.

Can anyone help me to create this job?