April 1, 2013 at 1:42 pm
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
April 2, 2013 at 4:32 am
I am having a very big Fixed length file and I having the layout of the file but to create a table in sql server 2008 giving hard time. Any solution to fix this problem.
April 3, 2013 at 8:17 am
I'm not entirely sure of what I may be missing here, but could you just add another data flow task after the initial data flow task and use your SELECT statment on an OLE DB Source to INV_DATA within that data flow? That way, the first data flow would finish before running the next data flow.
April 3, 2013 at 7:05 pm
That is what I ended up doing. I was trying to drag and drop the data flow and it wouldn't work. I found an online article that stated to double click on the data flow. That worked. Thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply