[help] How do I have Asp.net kick off an SSIS Package on a different server?

Hello, I was wondering if someone can help me with an ASP.NET question. We have been having troubles with our web server, and I don't know where else to turn.

We are running an asp.net (vb.net) with IIS on ourWebServer.

We are running Sql Server 2005 / SSIS on ourDatabaseServer.

SQL Server and IIS are running on separate machines. This is by design.

We are trying to get our Asp.net to kick off an SSIS package, but we are unable to do this since the software is on separate servers.

(If both are installed on the web server, we can directly call the SSIS package. If both are installed on the Database Server, we can implement a web service on the Database Server, and call that web service from the Web Server.)

Thank you,

~Le

How are you trying to do that?

|||

>>How are you trying to do that?

Currently we are not doing it, which is why I am here.

On development, we are able to call the SSIS directly from Asp.net, as long as IIS and Integration Services is on the same machine.

In a different development environment, IIS is installed on the Machine01 and ISS + Integration Services is installed on Machine02. The Asp.net page runs off of Machine01 and calls a Web Service that is running on Machine02. That Web Service is able to activate the SSIS since Integration Services is on the same machine.

On our production server, we will not have either luxury. IIS is installed on the Web Server and Integration Services is installed on the Database Server.

So, how can we run it in our production environment?

~Le

|||

Sorry for the late reply, but I still dont understand that what will change in new development environment.

Currently you have SSIS on database server and asp.net(with IIS) on different machine and later its going to be the same. You can have the webservice running either on your asp.net machine or on Machine02, whichever you prefer.