I am new to SSIS. I am creating a package which does the following:
1. Get data depending on a SQL Query (in SSIS I did this as a OLEDB Source with SQL Command)
2. Data conversion
3. Then insert the data into a SQL table.
For Step 3, which task Should I use. Id I Use OLE DB destination, into a table, it is giving me Errors.
So Can I access the Output of the Data conversion step in Execute SQL task, if I use it instead of OLEDB destination?
View Complete Post