Import Excel data to SQL Server Using SSIS package with c#


  • Hi All,

    I have a requirement to import excel data to SQL Server database using with c#. I am uploading excel data using file upload control and executing .dtsx package using 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 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 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 with c# . Thanks in an advance...

    Wednesday, April 11, 2012 6:50 AM

All replies

  • What application pool are you using to run the site? What is its identity? Can that user access SQL Server ?

    Can you attach debugger to the remote machine and check where it is failing?

    Tatyana Yakushev []

    Wednesday, April 11, 2012 5:03 PM