September 25, 2009 at 3:14 am
Hi.
We want a program that takes a excel-file and import that into SQL-Server. We have made a solution that we have a C# program that imports the excel file to a table in SQL-Server. The datatype for that column is VARBINARY[MAX]. That works great. Then the same C# program will trigger a SSIS job that will extract the excel file locally on the server, and then import it to the db. By doing this we will have no problem with diffrent paths. (The C# program is run locally on a pc and will have diffrent paths then SQL-Server). But we dont know how to create a raw file from SSIS when the data is in the db of datatype DT_IMAGE. Is this possible at all?
Does anyone has a answer to this.
Thanks in advance.
Anders
September 26, 2009 at 11:47 am
Have you tried outputting to a raw file destination? I believe this would do the trick, but I have not tried writing binary data.
September 28, 2009 at 12:23 am
Yes, I have tried that and the component RAW FILE DESTINATION can't take a BT_IMAGE as datatype. So I guess it need to be converted first, but how and to what?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply