The problem of calling the dts package~~

slowstep

I have no problem with the console program written in c#, but it cannot be ported to the web.
The phenomenon is that the program does not go down in the package.LoadFromSQLServer sentence, the web page has been waiting until it times out
My procedure is as follows:
string packageName = "test";
object pVarPersistStgOfHost = null;
DTS.PackageClass package = new DTS.PackageClass();
try
{
package.LoadFromSQLServer(".","sa","", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null, null, null, packageName, ref pVarPersistStgOfHost);
Console.WriteLine("DTS Package Executing..");
package.Execute();
Console.WriteLine("DTS Package Completed");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
package.UnInitialize();
package = null;
}

slowstep

Top down

crabhero

Is the same database
It may be that the asp.net running account has insufficient permissions to access the database. The console defaults to the current login user permissions

slowstep

"Maybe the asp.net running account has insufficient permissions to access the database"
Access to sql database or data warehouse database?

I did a few more tests, and the problem became clear: The dts package I executed can be executed if the task about "Analysis Services Processing Task" is removed. Once it is added, the LoadFromSQLServer part will not survive.

crabhero

I thought the database permissions were overturned by lz...Look again

slowstep

There is no problem in the console, but there is a problem in the web,
Ascrabherosaid, the console defaults to the current login user authority, while the web is the aspnet user.
(Building the dts package in sqlserver, "Analysis Services processing task" does not need to fill in the login user and password, so you must use the windows authentication method to log in)
So I think the problem may lie in the login user.

Unfortunately, I can't find a solution.

Hope friends enlighten me!

richwolfbobo

Youqing Bangding