Master Package containing
a) A sequence of SSIS packages
c) Precedence constraint to
b) Analysis Services Processing Task to process our cubes
2. SQL Agent Job which runs the Master Package
Taking the cube processing in SSIS package and putting SSAS commands into the job
This seems to work, but we don't know why it is not working.
Native OLE DB\Microsoft OLE DB Provider for Analysis Services 10.0
as OLE DB provider, as connection information
In BI SSAS cubes are working fine.
But SSAS cubes in SSIS package showing the following error
"Internal error: The operation terminated unsuccessfully. "
Pls help me to solve
View Complete Post