Hi, I have a package I'm working on in which I'm loading data from a set of flat files to tables. I'm using the Data Flow Task Plus to accomplish this as the tables involved may change over time, so I want the package to be as dynamic as possible. This is all working as expected.
When loading the tables, I don't really want to have to truncate the destination table first. I would rather use a table difference component and handle inserts/updates/deletes that way but with the single THUNK_COLUMN in the DFTP I'm not sure how I would go about that. Can the two be used together?
Thanks,
Alan