You will also have a separate connection manager for each file format.

This is the most straightforward approach but tedious to code.

You can use a for each loop to bring back each file name. You will need a step to determine what table a file needs to be loaded to....

Another approach for when the sheets are not logically named is:

In a for each loop,

on the collection page,

use enumerator for each ADO.NET Schema Rowset Enumerator

...

One problem I run into with these articles is only one inch of the code is visible at a time. Is there a way I can get more of...

Put the company name in a variable. You will be able to access it in a derived column task.

One approach to getting the end of the previous month is to add a derived column transformation to the data flow task that reads the Excel file. It could...

Sometimes Excel will have blank rows after the rows you can see data in. You will need to check for that.

I finally tracked it down by making a copy of the package and deleting things until the error went away. The problem was with a script component. I...

Where you read in the file, did you set the error handling to either ignore or reroute bad rows?

The next step should be a conditional split to only pass the...

They are all true.

Here is a section of script component that will count the commas and put the remaining text in double quotes.

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

...

Try defining the row of the file as one long record and run it into a script component. The script component should count over 24 commas and put anything...

I have only done it as a child package. You might also take a look at creating event handlers. Perhaps some of what you want to do could...

One possibility is to create a package with the common logic and call it as needed.

It looks like the directions in the website are for script components, not script tasks. I was able to follow the directions in a script component and when I...