Re: LoadFromSQLServer of Packages with Analysis Services Processing Tasks

#1

Make sure they and any other tasks that connect to them are executing on
"The main Package thread" (Workflow properties)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mohammad" <mohammad.shaahinfar (AT) ftb (DOT) ca.gov> wrote

Quote:

Hi,

When I use the following to execute a package, the
LoadFromSQLServer statement hangs on packages with
Analysis Services Processing Tasks.

Set oPkg = Server.CreateObject("DTS.Package")

oPkg.LoadFromSQLServer "myServer", uid, pwd,
DTSSQLStgFlag_Default, "", "", "", "TestDTS"

oPkg.Execute

Any ideas?

Thanks in advance.

#2

I made sure those tasks and any other tasks connecting to
them have their execution option set as you suggested.
The option on the OLAP task were already set. I only had
to change the option on the connecting tasks. The problem
persists as long as an OLAP task is in the package.

Quote:

-----Original Message-----
Make sure they and any other tasks that connect to them
are executing on
"The main Package thread" (Workflow properties)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mohammad" <mohammad.shaahinfar (AT) ftb (DOT) ca.gov> wrote in
message
news:036001c38838$07032aa0$a301280a (AT) phx (DOT) gbl...
Hi,

When I use the following to execute a package, the
LoadFromSQLServer statement hangs on packages with
Analysis Services Processing Tasks.

Set oPkg = Server.CreateObject("DTS.Package")

oPkg.LoadFromSQLServer "myServer", uid, pwd,
DTSSQLStgFlag_Default, "", "", "", "TestDTS"

oPkg.Execute

Any ideas?

Thanks in advance.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: LoadFromSQLServer of Packages with Analysis Services Processing Tasks

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: LoadFromSQLServer of Packages with Analysis Services Processing Tasks - 10-01-2003 , 12:32 PM

Re: LoadFromSQLServer of Packages with Analysis Services Processing Tasks - 10-01-2003 , 01:21 PM