In this tutorial, we will set up a Microsoft Integration Services task, which will trigger one or more scheduled reports. We will assume a pre-existing Analysis Services Processing task, and one or more scheduled reports.

To set up an integration services task:

  1. Open your existing Integration Services project in Business Intelligence Development Studio.
  2. In Control Flow, open the Toolbox and drag a web service task into the window.
  3. Set the task to run after the existing Analysis Services Processing Task as normal.
  4. Right-click the new task, and select Edit.
  5. On the General page, configure the Web Service details:
      • For the HTTPConnection, select New connection.
      • The Server URL should be: http(s)://yourwebserver/AnaplanXLWeb/WebServices/SchedulingServer.svc?wsdl.
      • ‌Set up the credentials and other properties for access to the website:
      • Select OK to confirm the connection, when successfully tested.
  6. Select a local file path for the WSDLFile property, set the OverwriteWSDLFile property to True, and choose Download WSDL. If desired, select a Name and Description for the task.
  7. On the Input page, the input boxes should now be available. Select SchedulingServer for the Service, and RunSchedule for the Method.
  8. For the ScheduleNameSearchPattern either enter the name of the schedule you want to run, or a simple pattern, using an asterisk (*) as the wildcard. For example, to match all schedules with names starting with PostCubeBuild, enter PostCubeBuild* into the textbox.
  9. On the Output page, select a variable of type Object to store the return value.

The setup is finished. The schedule should run when the preceding tasks have been completed.