Post reply

synchronize cube using sql agent

  • December 3, 2014 at 9:44 am

    #313519

    I have created an XML script using synchronization wizard. It has the source connection, but no target connection. I ran it from ssms with my query window connected to target ssas db. I want to automate this as a job on sql agent. How can I modify this script to run it from sql agent so that it syncs correct rtarget ssas db.

    XML Script copied below.

    {

    <Synchronize xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

    <Source>

    <ConnectionString>Provider=MSOLAP.4;Data Source=myserver;ConnectTo=10.0;Integrated Security=SSPI;Initial Catalog=mycube</ConnectionString>

    <Object>

    <DatabaseID>mycube</DatabaseID>

    </Object>

    </Source>

    <SynchronizeSecurity>CopyAll</SynchronizeSecurity>

    <ApplyCompression>true</ApplyCompression>

    </Synchronize>

    }

    Thank you for your help.

  • December 4, 2014 at 6:52 am

    #1762698

    In your SQL Agent job step where it asks for server, use the target server (this is where the script will be executed and what you will synchronize to).

    I'm on LinkedIn

  • December 4, 2014 at 8:01 am

    #1762732

    Thank you. That makes sense.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply