CODEWITHSUNDEEP
sql-serverexcelssis
TheVavs
TheVavs

Reputation: 53

SSIS convert excel to text file and import

I have a recurring issue with importing Excel spreadsheets into SQL Server. As a work around, I am trying to convert the worksheet to a text file, comma delimited. I can convert the excel file to text but cannot seem to then import the text file into SQL. When I try to create a path between the text file and the OLE DB destination. I do notice that the flat file is showing as a destination ("Flat File Destination"). Is there a way to get this to go from the destination text file to SQL after doing the transformation to text?

Upvotes: 0

Views: 3157

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31785

If you are trying to do this in one dataflow, turning your 1st destination into a source, you can't do it like that.

If you have a dataflow that moves the data from an Excel Source to a Flat File Destination, you then need to create a second dataflow that uses the Flat File as a SOURCE, and moves the data to an OLEDB Destination.

Just place the second dataflow after the first one on the Control Flow.

Upvotes: 1

Related Questions