SSIS script - how to export multiple tables and re-import them using script

See more:

SQL

.NET

server

SSIS

script

Task

Hi All,

I have a requirement to export 100-150 tables from Sybase out to .csv files on a daily basis.
I also need to export the metadata of each table (column names + data types) so when i import them, i dont have to guesstimate the metadata.

What I have tried:

I have gotten this first part done successfully using the code from here:

Welcome To TechBrothersIT: C# - How to Export Data from SQL Server Table or View to Text File in C Sharp[^]

However i believe i need the metadata when importing these files back, otherwise how would the code know which data type to set the column to?

I am still not sure about the code for the 2nd part, which is, how to import these files back into tables using code. I assume this is where i need the previously generated metadata to figure out the data types.
3rd party add-ons are not an option, hard requirement to to use file based CDC hence this is my only option.
Anyone can help on this?