Last post Apr 11, 2012 02:53 AM by yjeevanrao
Apr 11, 2012 02:53 AM|yjeevanrao|LINK
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...