Data Flow Task Plus + Table Difference

27 views
Skip to first unread message

coavlanche

unread,
Feb 23, 2024, 12:04:25 PM2/23/24
to COZYROC
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
Reply all
Reply to author
Forward
0 new messages