DTS running in C# does not work when processing olap cube

[Joel Leong]

I use C# to invoke DTS. The DTS run successfully if no
process cube function in it. But after i add process cube
function, the ASP.NET page hang.

I even impersonate ASP.NET to an account with OLAP
Administrator and System administrator. it jus hang
there. So what is the problem I'm having? It is working fine when no
processing OLAP command in it.

Package2Class package = new Package2Class();

try
{

if (mode == AppEnums.ProcessCubeMode.FullProcess)
{
if (useTrustedConnection)
{
package.LoadFromSQLServer(serverName, null, null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedC onnection,
null, null, null, "ATMOnlineNET: Full Process OLTP and
OLAP", ref pVarPersistStgOfHost);
}
else
{
package.LoadFromSQLServer(serverName, userId, password,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,
null, null, null, "ATMOnlineNET: Full Process OLTP and
OLAP", ref pVarPersistStgOfHost);
}
}

[Scott Allen]

Hi Joel:

Are you using AspCompat="true" in your @ Page directive? I believe the
cube processing custom task is an STA component and will need this
setting, particularly since you are using impersonation.

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 19 Apr 2005 20:48:09 +0800, "Joel Leong"
<ch******@hotmail.com> wrote:

I use C# to invoke DTS. The DTS run successfully if no
process cube function in it. But after i add process cube
function, the ASP.NET page hang.

I even impersonate ASP.NET to an account with OLAP
Administrator and System administrator. it jus hang
there. So what is the problem I'm having? It is working fine when no
processing OLAP command in it.

Package2Class package = new Package2Class();

try
{

if (mode == AppEnums.ProcessCubeMode.FullProcess)
{
if (useTrustedConnection)
{
package.LoadFromSQLServer(serverName, null, null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrusted Connection,
null, null, null, "ATMOnlineNET: Full Process OLTP and
OLAP", ref pVarPersistStgOfHost);
}
else
{
package.LoadFromSQLServer(serverName, userId, password,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,
null, null, null, "ATMOnlineNET: Full Process OLTP and
OLAP", ref pVarPersistStgOfHost);
}
}

[Joel Leong]

Thanks, your solution really did the job. I owe you a lunch buddy!
"Scott Allen" <sc***@nospam.odetocode.com> wrote in message
news:hr********************************@4ax.com...

Hi Joel:

Are you using AspCompat="true" in your @ Page directive? I believe the
cube processing custom task is an STA component and will need this
setting, particularly since you are using impersonation.

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 19 Apr 2005 20:48:09 +0800, "Joel Leong"
<ch******@hotmail.com> wrote:

I use C# to invoke DTS. The DTS run successfully if no
process cube function in it. But after i add process cube
function, the ASP.NET page hang.

I even impersonate ASP.NET to an account with OLAP
Administrator and System administrator. it jus hang
there. So what is the problem I'm having? It is working fine when no
processing OLAP command in it.

Package2Class package = new Package2Class();

try
{

if (mode == AppEnums.ProcessCubeMode.FullProcess)
{
if (useTrustedConnection)
{
package.LoadFromSQLServer(serverName, null, null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTruste dConnection,
null, null, null, "ATMOnlineNET: Full Process OLTP
and
OLAP", ref pVarPersistStgOfHost);
}
else
{
package.LoadFromSQLServer(serverName, userId, password,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default ,
null, null, null, "ATMOnlineNET: Full Process OLTP
and
OLAP", ref pVarPersistStgOfHost);
}
}

[Scott Allen]

Just glad to be of help ...

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 19 Apr 2005 23:06:49 +0800, "Joel Leong"
<ch******@hotmail.com> wrote:

Thanks, your solution really did the job. I owe you a lunch buddy!
"Scott Allen" <sc***@nospam.odetocode.com> wrote in message
news:hr********************************@4ax.com.. .

Hi Joel:

Are you using AspCompat="true" in your @ Page directive? I believe the
cube processing custom task is an STA component and will need this
setting, particularly since you are using impersonation.

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 19 Apr 2005 20:48:09 +0800, "Joel Leong"
<ch******@hotmail.com> wrote:

I use C# to invoke DTS. The DTS run successfully if no
process cube function in it. But after i add process cube
function, the ASP.NET page hang.

I even impersonate ASP.NET to an account with OLAP
Administrator and System administrator. it jus hang
there. So what is the problem I'm having? It is working fine when no
processing OLAP command in it.

Package2Class package = new Package2Class();

try
{

if (mode == AppEnums.ProcessCubeMode.FullProcess)
{
if (useTrustedConnection)
{
package.LoadFromSQLServer(serverName, null, null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrust edConnection,
null, null, null, "ATMOnlineNET: Full Process OLTP
and
OLAP", ref pVarPersistStgOfHost);
}
else
{
package.LoadFromSQLServer(serverName, userId, password,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Defaul t,
null, null, null, "ATMOnlineNET: Full Process OLTP
and
OLAP", ref pVarPersistStgOfHost);
}
}