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.