Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS to IMPORT and then EXPORT to/from EXCEL Expand / Collapse
Author
Message
Posted Monday, April 01, 2013 1:42 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 24, 2014 9:05 PM
Points: 387, Visits: 418
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
Post #1437592
Posted Tuesday, April 02, 2013 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 4:55 AM
Points: 1, Visits: 6
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.
Post #1437818
Posted Wednesday, April 03, 2013 8:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:46 AM
Points: 223, Visits: 199
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.


Post #1438363
Posted Wednesday, April 03, 2013 7:05 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 24, 2014 9:05 PM
Points: 387, Visits: 418
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.
Post #1438632
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse