none
Import Excel data to SQL Server Using SSIS package with Asp.net c#

    Question

  • 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.

    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 [PredixionSoftware.com]

    Wednesday, April 11, 2012 5:03 PM