Dynamic SSIS Package (c#) using ManagedDTS
Budget: ₹600 – ₹1,500 INR
Hi
We need to create some dynamic basic SSIS packages(.DTSX).
It will be a very basic package at the moment with 1 DFT and 1 execute SQL task. Where from ExecuteSQL Task you need to get the Latest Date from a Table(Tab1) and then in DFT there will be a Source and Destination OLEDB but from source you need to insert only the data after the date coming from execute sql task.
This is kind of an Incremental Load
We need to create some dynamic basic SSIS packages(.DTSX).
It will be a very basic package at the moment with 1 DFT and 1 execute SQL task. Where from ExecuteSQL Task you need to get the Latest Date from a Table(Tab1) and then in DFT there will be a Source and Destination OLEDB but from source you need to insert only the data after the date coming from execute sql task.
This is kind of an Incremental Load