The Analysis Services Execute DDL task uses an Analysis Services connection manager to connect to an instance of Analysis Services or an Analysis Services project. For more information, see Analysis Services Connection Manager.Integration Services includes a number of tasks that perform business ...
Step 5:Drag and drop the Analysis Services Execute DDL Task from the Toolbox onto the Control Flow of the SSIS package and connect it to the Script Task configured earlier. Open the Analysis Services Execute DDL Task editor, click on DDL in the list box on the left, and set the ...