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 our Web Server.
We are running Sql Server 2005 / SSIS on our Database Server.
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.)
~Le
We are running an asp.net (vb.net) with IIS on our Web Server.
We are running Sql Server 2005 / SSIS on our Database Server.
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.)
~Le