• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1317
  • Last Modified:

In memory/stream Excel to Dataset/DataReader


i have an sql server integration services package script component (.net) which reads in a bunch of heterogenous files various business partners via HTTP... some of these are excel files. i'm assuming that i will not have permission to access the file system on the machine running sql server to write the excel file. how can i read the excel data into a datareader/dataset without saving the file to disk?


1 Solution
You can store it in a dataset as a binary array.  Add a base64Binary column to the dataset and store the streamed data as a byte[] in that field.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now