Post reply

Parellel Schedule Of SSIS package

  • November 28, 2008 at 2:56 pm

    #202150

    I have to load a data mart...for that I want to run my dimension table load parallel.

    So say for example I have 5 dimesion tables

    DIM1

    DIM2

    DIM3

    DIM4

    DIM5

    I can create a sql server agent SSIS job with 5 step and start all the step at same time.

    After this I want to start my 4 fact table load parallel, I want to start all the job as soon as all the dimension table load is over …is there anyway I can make a sql server agent job to start after the completion of another job.

    I am talking about creating dependency between SQL Server Agent job & not dependency between steps in a single job.

    Will appreciate any help/pointer to solve this problem ..?

  • December 1, 2008 at 4:43 pm

    #905982

    You can use T-SQL type step at the end of your job to call the other job

    e.g. exec sp_start_job @job_name = 'job name '

    Else you can create a SSIS package with the execution flow as desired.

    HTH

    ~Mukti

  • December 2, 2008 at 12:12 pm

    #906444

    You can start SQL Job using script task, after you finish loading your dimensions - last step in your package execution. Check this script for ideas how to use SQL Job Agent API.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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