Solved

In memory/stream Excel to Dataset/DataReader

Posted on 2006-06-20
3
1,286 Views
Last Modified: 2012-05-05
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
Comment
Question by:irajani
3 Comments
 
LVL 25

Accepted Solution

by:
dstanley9 earned 500 total points
ID: 16942846
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Summary: Persistence is the capability of an application to store the state of objects and recover it when necessary. This article compares the two common types of serialization in aspects of data access, readability, and runtime cost. A ready-to…
We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now