I have a directory with 200+ txt files to import into SQL tables in a database. Each file name is the exact table name in the database(without the file extension, obviously). I am looping through each file with a for each loop and a variable is mapped and
set in the source connection properties for the Expressions -> ConnectionString property, so each name will go into that variable without the file extensions, correct? Now, I set the variable name to the table name in the destination for the table
name under "Data Access Mode", but it is giving an error...do I have to assign variables to each part, (Connection String and Name)? Does anyone have a quick setup for this?
View Complete Post