I see this:

Is this a blog post, or do you have a question?

Appending to a table using SSIS is as simple as creating a data flow, from source to table, and executing...

ok Phil first off, thank you thank you... for taking the time... i found the problem... and yes i am going to take myself out back and beat myself...

I'm not sure how much it matters, but I think the conn string extended properties should contain 'XML', as follows:

Data...

I am going to give up, I'm afraid.

I don't know why you would get any sort of 'workgroup information file' error when opening an Excel file (because I thought only...

No need to recreate anything. Once the drivers are there, they will (or should!) get picked up when you next run.

It looks like you have this covered already, but your SSIS development experience will be a happier one if you have both 32- and 64-bit versions of the ACE driver...

Please post your sample data in a consumable format, along with DDL. See here if you are unsure what is required. Many people here will not open Excel attachments,...

Thanks for what? You haven't asked a question.

If you expand the Server Objects/Linked Server/Providers node of your SQL instance, what versions of the ACE driver do you see?

Actually, it's not 100% clear...

OK, interesting.

How are you populating your enumerator? Can you share some details?

You could consider adding some logging (Dts.Events.FireInformation, maybe) to check the contents of the enumerator before entering the Foreach...

Echoing Frederico's comment, you should not be installing SSDT on the server.

As you can see from this link, you'll need Enterprise or Standard Edition to run Integration Services. (Or...

And if it's not that, it will probably be a permissions issue. Does the SQL Agent user have the necessary access to the file system?

It ensures that the FK column in the child table matches...

That's not how SQL Server works. All the FK does is enforce data integrity. You can check for yourself by trying to insert a row in the child table which...