I have an SSIS package that has an "Execute DDL Task" Control flow task that contains the xml script from the Deployment Wizard. This control flow task has a connection manager that when tested connects successfully. however, when I execute the control flow task I get the following error:
SSIS package "BrokerageCubePackage.dtsx" starting.
Error: 0x0 at Deploy Cube, Analysis Services Execute DDL Task: No connection manager is specified.
Error: 0x0 at Deploy Cube, Analysis Services Execute DDL Task: DDL is not valid.
Error: 0xC0024107 at Deploy Cube: There were errors during task validation.
SSIS package "BrokerageCubePackage.dtsx" finished: Success.
The program ' BrokerageCubePackage.dtsx: DTS' has exited with code 0 (0x0).
The connection manager is specified in the task. I can build, deploy and process the cube in BIDS with no errors. I can build and deploy the cube successfully with the Deployment Wizard. It's just when I try to execute the control flow task that contains the xml script that I encounter problems.
Any help is greatly appreciated.