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

Automate MOSS 2007 Backup

Hi...

To automate the backup activity of MOSS 2007 portal Server we use to do the following two steps...
1. Creation of Batch file: Here we create a batch file which will execute the stsadm.exe, passing necessary parameters to perform the backup activity in command prompt.

Batch file Code as follows:

@echo off
echo ====================================================
echo Backup Script For Office SharePoint Server 2007
echo ====================================================
@echo off

RD D:\Backup\SOME FOLDER /S /Q
MD D:\Backup\SOME FOLDER

stsadm.exe -o backup -directory "\\SOME FOLDER" -backupmethod full -item "Farm" -overwrite

echo completed

2. Scheduled Tasks: In this step we can create a scheduled task (Control Panel --> Scheduled Tasks) to execute the batch file at a preferred frequency of time.

Thus your backup is automated, its advisable to the monitor free space available on the disk regularly...

Now recently there are new tools available to take backups.And they come with more cool features. If you use some interesting tools or any other technique, feel free to let us know :)

Warm Regards
Mohammed Fauzi ~ 4Z