dbTalk Databases Forums  

Load and compile DTS packages with Analysis Services Processing tasksin it?

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


Discuss Load and compile DTS packages with Analysis Services Processing tasksin it? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jonas Montonen
 
Posts: n/a

Default Load and compile DTS packages with Analysis Services Processing tasksin it? - 06-23-2005 , 01:56 AM






Hi All.

We have this ActiveX Script Task that we call to load about 50 DTS
packages from file into our SQL Server.
All packages except the ones with "Analysis Services Process Task" works
fine.

We do like this:
....
Set oDTSPackage = CreateObject("DTS.Package")
oDTSPackage.LoadFromStorageFile SourcePath &
f1.Name, ""
....

The "LoadFromStorageFile " statement never ends for the Analysis tasks
packages. Anyone experienced this before?

The cubes that are refered to in the tasks exists, they are restored
from a CAB in the step before calling "Load DTS from file" package.

Regards
// Jonas Montonen

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.