Click here to Skip to main content
15,886,919 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Dear All,

I want to upload excel data into my sql table by using of SSIS package in asp.net.

My application details are -
ASP.net 4.0
SSIS 2008
excel 2007

If i directly run my asp.net application code(Web server) then my file uploaded successfully but when i hosted my application in IIS 7.0 and then upload i am facing below issue

"external table is not in the expected format"

my xlsx file size is approx. 30 mb.
Please help me.
if you need my test code then i will provide all.

Regrads,
Jangid
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900