Post reply

DTS Execution Error, without sql server installation

  • August 13, 2009 at 3:24 am

    #209408

    Hi All,

    I am stuck up with a problem. I have created a DTS package to import a excel in to SQL server. I execute this code through a C# program through a web page. I was working in a test environment were my code, sql server where lying the same server. It was working fine. Now I have to move it to live server. Here we have the sql server installed in a seperate system and the website is in a seperate webserver, this server does not have a sql server installed in it.

    Now when i ran the code I got a com exception. I solved this issue by installing the SQL Server DTS runtimes. Then I stopped getting this exception. Now the package.execute() seems to executing, but the transformation is not happening.

    When i googled the problem, there were some post explaining that even the execution of DTS through code required DTS to be installed, which I would not be able to.

    Please let me know if there is any way.

  • August 13, 2009 at 9:34 am

    #1038796

    There are a few things if your SQL Server executing the package is 2000 that is you have a DTS package then you need to look for and download and install the DTS redist package in both the SQL Server and web server, make sure Asp.net have permissions to run the package because it runs in the context of Asp.net. If you are in SQL Server 2005 then you need to be running at least SQL Server standard edition in the server running SQL Server and give the Asp.net runtime relevant permissions because without the SSIS runtime your code will not run.

    Kind regards,
    Gift Peddie

  • August 13, 2009 at 10:48 am

    #1038847

    It might be easier if the DTS package executes on the SQL Server. Then you only need to figure out how to invoke it from the web server.

    You could create an unscheduled Agent job that runs the package, then create a stored proc that uses msdb.dbo.sp_start_job to run it. The C# program can connect to the db and execute the stored proc (if connection uses a login with the necessary permissions).

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply