CODEWITHSUNDEEP
ssis
AdamS
AdamS

Reputation: 23

Reading excel from DB (varbinary) in SSIS

First I'd like to say that I'm brand new to SSIS so bear with me if this is a very basic question. I've searched and cannot find an answer.

I need to read data from SQL Server that is stored in a varbinary column that contains an excel document. I then need to store this data into another table with the appropriate columns (pre-defined format).

My question is essentially... How do I read this varbinary data into something I can work with and then insert into another table?

Upvotes: 2

Views: 1572

Answers (1)

user756519
user756519

Reputation:

You could use Export Column Transformation available within the Data Flow Task to read the varbinary data and then save it as a file on local disk where the SSIS package is running.

MSDN documentation about Export Column transformation.

Sample: The Export Column Transformation on BI Monkey

Using another data flow task, you can read the saved file and import the data into the table of your choice.

Upvotes: 1

Related Questions