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

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
0
irajani
Asked:
irajani
1 Solution
 
dstanley9Commented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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