one technical limitation: I found out the hard way you can't truncate a table if referencing it through a synonym...

And actually, each target table must exist before the oledb destination with that table name fires up. However if needed, in the same "for each" loop a simple precedent...

I attached a screen shot of one way to have variables for object names for the OP, I am sure you already know how to do this for an ExecuteSql...

If using Execute Sql task, make the sql text an expression and use variables for table names

If using oledb destination in data flow task, the data access mode property of...

[I am not able to use variable due to there are almost 20 data flow tasks in SSIS package and I need to use more variables.]

Did you consider to use...

Jeff your work is amazing. I am learning a _lot_ from it. Thank you!

One way to be certain that SSIS will process data elements with exactly the data type you want is to make all the explicit conversions yourself from a "type controlled"...

Sorry perhaps I wasn't clear. Use script to make your connections also. Do not use a component for anything. Then you will have no trouble handling an error from...

use C# script task to do the work.

trap the error in a loop and ignore it.

Hi Paul,

<<Fabian Pascal's work is for entertainment value>>

Yes I can see, based on the approach offered in your article, that you would consider such commitment to Codd's work "zealotry" and...

<<You've spent enough time and energy on your debate here, to write half the article,>>

Not even in the same continent Jack. A few typo ridden, before the morning commute...

@stefan.

In a previous career, I was in the printing industry (20+ years). I learned a lot about the concept of "quality" in that career.

As professionals, we get...

Well of course the obvious inference in the statement "doesn't happen" is that "doesn't happen to ME".

I truly have never had that happen in years of on and off formal...

I have been trying to emphasize, and explain how I do this, which is precisely TO emphasize the conceptual, general principles for creating good abstractions/models at the first meetings. ...

Then I misunderstood, I stand corrected, and I need to apologize to you for considering that you were just making some silly projection of what I would do.

The point...