Load script from file to SQL tables dynamically
I have the following script that I use in SSIS to transfer data from a
data file to a SQL table. I want change the code so that I** don’t** need the column names
in the file to be the same as the column names in the SQL tables to which the files are loaded.
It is important to note that the columns of the files and the columns of the SQL tables into which the
data is loaded are dynamic.