SSIS - Analysis Services Execute DDL Task: No connection manager is specified.

• clay.powell

  SSC Enthusiast

  Points: 132

  More actions

  July 25, 2012 at 8:00 am

  #392826

  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 '[22784] 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.

  Thans,

  cpowell