Please not: I am new to SSIS and learning stuff and implementing in my project
I dont see a Execute SQL Task in Data Flow.
So I am reading Data Source using "OLEDB Source" - Data Access = SQL Command. Now I want to load the data to my target table.
Here is what I will like to have:
- Check if Record exist after I do above read.
- If Exists, Truncate Target Table (OLEDB Target) and Load ALL Data
- Else No Action.
What transformations I sould use and how th flow should be?
View Complete Post