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

[Fail] Could not add ASPNET user to SQL Server.

Ok here's my setup

1. Installed msde 2000 with sp3.
2. started the SQL Server and SQL Server Agent.
3. Ran IBuySpy Store Installation, when I ran the configuration I get error on bottum.

10:51:55 PM Tuesday, September 23, 2003: [Checking system requirements]
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected a local instance of SQL Server.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected .NET Framework.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected Internet Information Server (IIS).
10:52:03 PM Tuesday, September 23, 2003: [Begin Sample Configuration]
10:52:05 PM Tuesday, September 23, 2003: [Pass] Created IIS virtual directory.: StoreVBVS
10:52:05 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:52:22 PM Tuesday, September 23, 2003: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
10:52:22 PM Tuesday, September 23, 2003: [Done]

Can someone please tell me step by step on what I need to do and where to do it to get this working, thanks !!!did you add it via users in your db? when you xpand our db in sql server xplorer, you can add users using "users"...

HTH