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 |