Additionally, the MSDN/BOL page on CREATE TABLE mentions this "feature":

"[ type_schema_name. ] type_name

Specifies the data type of the column, and the schema to which it belongs. The data type can...

Maybe my reading comprehension is off this morning, but it seems that, according to the link specified, both of the last two options are correct:

When CHECKSUM is enabled for...

At first glance, I'd think about setting up two connection managers for the Excel files, one with the path being the first expression, the other with the path being the...

The underscore should not need an escape character. Double up the backslashes to get one into an expression string.

"S:\\" + "_TestFolder" gives S:\_TestFolder

If there are columns in table 2 that are string datatypes (char or varchar), there are some things to consider when trying to get the lookup to match.

If there are...

Is you're package actually failing (hard stop) or is it just not loading the file? There's a difference.

Make sure you have a wildcard in your foreach container's string (eg....