DTSX failed to execute when invoked from web application ASP.Net

Hi there...

Usually i use to have a console application to execute a DTSX file(SQL Server Integration Service - Business Intelligence application) And schedule it to run for automated execution.
(http://mohammedfauzi.blogspot.com/2009/10/how-to-run-dtsx-programmatically.html)

This time the requirement was to run another DTSX file on demand by end user. So we decided to go for a web application.

I made use of the same code which i used in previous post on submit click event here. Earlier i was getting permission related errors. The issue was solved when i gave permission for the respective user on whose credential the request is executed as anonymous user. When this issue was fixed, The other issue came was that the "Execution Failed" When the web page was executed from outside. Apparently it was working great when executed from Visual studio! Still the permission related issue was there...

After lots of Googling & trials found the solution!!!

Solution:
you need to the following:
1. In IIS, Right Click the Project -> Properties
2. Click on ASP.NET tab
3. Click 'Edit Configuration' button
4. Click 'Application' Tab
5. Under Identity Settings -> Click the Checkbox 'Local Impersonation'
6. Give the user name & password for local user of the machine(who has access to run the DTSX applicaiton)

Thats it... now when you run the web application it works fine :)

Hope It Helps...

Regards
Fauzi

Unable to start debugging on the web server. The web server is not configured correctly...

Hey all:

When you build a web solution in Visual studio, if the following error message is shown:

"Unable to start debugging on the web server. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information."

There can be two reasons...

A) The directory where the web application stays may not be configured as web application.

Steps to Solve:
1. Right click the project folder & Click properties.
2. Select "Web Sharing" tab.
3. Choose the option "Share this folder" radio button & Edit Alias window will pop-up, Press OK and build the application.

B) The Frame work version may not be the appropriate one.
Steps to Solve:
1. Right click the project folder from IIS (Run>inetmgr), Click properties
2. Select ASP.NET tab & select the appropriate ASP.NET Version from combo box.
3. Press OK & build the application again.

Hope it is helpful...

Regards
Fauzi