Click here to Skip to main content
15,868,292 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi All,
I have a requirement to import excel data to SQL Server database using asp.net with c#. I am uploading excel data using file upload control and executing .dtsx package using asp.net with c#. For that I have created SSIS package MSBI to import data from excel to SQL Server and i deployed it. Then i started using of .dtsx(package) in asp.net to insert uploaded excel data into the SQL server. When i run the package records are inserting into the data. When i am executing the package using asp.net with C# in my machine it is working fine and those records are inserting into the database. When deployed and configured in IIS application server then it is throwing failure message. How can use SSIS package in asp.net with c# . Thanks in an advance...

Regards,
Jeevan.
Posted
Comments
bbirajdar 26-Apr-12 10:09am    
Reason for my vote of 1
Error message not mentioned. So the question is not clear

1 solution

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