0
Answer

Package is not running while run from iis

Ask a question
This program is running successfully in my computer. But when I run from IIS its not running. How Can I give the location of New Package1.dtsx in the program to run from iis.
 
private void Execute_Package()
{
string packageLocation;
Package ssisPackage;
Microsoft.SqlServer.Dts.Runtime.
Application ssisApplication;
DTSExecResult ssisPackageResult;
packageLocation = @"D:\New Package1.dtsx";
ssisApplication = new Microsoft.SqlServer.Dts.Runtime.Application();
ssisPackage = ssisApplication.LoadPackage(packageLocation, null);
ssisPackageResult = ssisPackage.Execute();
}