Bonediggler1
Technical User
Hello
I am trying to do the following via SSIS:
1)Extract data from SQL Server
2)Put this data into a recordset
3)Update the recordset (e.g. if column 1 has value "tomorrow" update it to say "today")
4)Export to Excel
I am not having trouble with any of this except #3. Not sure how to update data in a recordset. This could easily be done by storing the data in a physical table and running an Execute SQL task, but i'd rather do this in-memory.
Is this possible?
Thank you!!
I am trying to do the following via SSIS:
1)Extract data from SQL Server
2)Put this data into a recordset
3)Update the recordset (e.g. if column 1 has value "tomorrow" update it to say "today")
4)Export to Excel
I am not having trouble with any of this except #3. Not sure how to update data in a recordset. This could easily be done by storing the data in a physical table and running an Execute SQL task, but i'd rather do this in-memory.
Is this possible?
Thank you!!