I have an SSIS package that creates the temp table, then uses a data flow to import a CSV file from C:\SSIS\IMPORT (call it tmp001.csv). After the import into TEMP_INV_DATA, the control flow steps through a handful of tasks to transfer the data. The final step is to put the transformed data into INV_DATA table.
What I want to know is, how do I take the data just entered into INV_DATA and dump it to excel (xls, xlsx, or csv - doesn't matter to me) from a SQL Statement (SELECT * FROM INV_DATA WHERE CREATE_USER = 'INV_INTERFACE' AND CONVERT(VARCHAR(12),CREATE_TIMESTAMP,110) = CONVERT(VARCHAR(12),GETDATE(),110)) ?
Things I have tried: I tried adding another data flow item (Flat File Desintation), but I have to link it to the OLE DB Desitination and I'm affraid the package is going to flat file source -> OLE DB Destination -> then export (Flat File Destination) BEFORE any of the transformation.
Please let me know if you need anything else. Thank you