In memory/stream Excel to Dataset/DataReader

Hi,

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?

Thanks,

Imran
irajaniAsked:
Who is Participating?
 
dstanley9Connect With a Mentor Commented:
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.
0
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.

All Courses

From novice to tech pro — start learning today.