locked
regarding ssis - schedule 20 packages RRS feed

  • Question

  • Hi,

    how can we schedule 20 packages at a time in ssis


    • Edited by SSISJoostMVP Sunday, November 30, 2014 7:53 AM Title too general
    Friday, November 28, 2014 8:09 AM

Answers

  • Create a SQL Job and add 20 SSIS steps to that job. Please Mark This As Answer if it solved your issue Please Mark This As Helpful if it helps to solve your issue _____________________________________ Thanks, Shashikant
    • Proposed as answer by BI_Support Monday, December 1, 2014 5:22 AM
    • Marked as answer by Katherine Xiong Friday, December 5, 2014 12:07 PM
    Friday, November 28, 2014 9:26 AM
  • Then it should be wrapper package which calls the required 20 packages through execute package tasks.

    Please Mark This As Answer if it solved your issue
    Please Mark This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Proposed as answer by BI_Support Monday, December 1, 2014 5:23 AM
    • Marked as answer by Katherine Xiong Friday, December 5, 2014 12:07 PM
    Friday, November 28, 2014 5:58 PM
  • If they are related packages (same project/dependent) then you should create a master package with 20 execute Package Tasks. Or you can use a Foreach Loop to loop through all packages sequentially or even in parallel.

    Or else listen to Olaf Helper and create 20 jobs...


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter


    • Edited by SSISJoostMVP Sunday, November 30, 2014 1:55 PM
    • Proposed as answer by BI_Support Monday, December 1, 2014 5:22 AM
    • Marked as answer by Katherine Xiong Friday, December 5, 2014 12:07 PM
    Sunday, November 30, 2014 8:00 AM

All replies

  • Create 20 SQL Server-Agent Jobs, one for each package.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by BI_Support Monday, December 1, 2014 5:22 AM
    Friday, November 28, 2014 8:32 AM
  • Create a SQL Job and add 20 SSIS steps to that job. Please Mark This As Answer if it solved your issue Please Mark This As Helpful if it helps to solve your issue _____________________________________ Thanks, Shashikant
    • Proposed as answer by BI_Support Monday, December 1, 2014 5:22 AM
    • Marked as answer by Katherine Xiong Friday, December 5, 2014 12:07 PM
    Friday, November 28, 2014 9:26 AM
  • Do you mean make same schedule for all?

    If yes, put all the packages inside a sql agent job and link it to your required schedule.


    Please Mark This As Answer if it solved your issue
    Please Mark This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Friday, November 28, 2014 10:15 AM
  • I would suggest to use a series of sequence container and run only one package.
    Friday, November 28, 2014 5:10 PM
  • Then it should be wrapper package which calls the required 20 packages through execute package tasks.

    Please Mark This As Answer if it solved your issue
    Please Mark This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Proposed as answer by BI_Support Monday, December 1, 2014 5:23 AM
    • Marked as answer by Katherine Xiong Friday, December 5, 2014 12:07 PM
    Friday, November 28, 2014 5:58 PM
  • Then it should be wrapper package which calls the required 20 packages through execute package tasks.

    Please Mark This As Answer if it solved your issue
    Please Mark This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Yes
    Saturday, November 29, 2014 12:09 PM
  • If they are related packages (same project/dependent) then you should create a master package with 20 execute Package Tasks. Or you can use a Foreach Loop to loop through all packages sequentially or even in parallel.

    Or else listen to Olaf Helper and create 20 jobs...


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter


    • Edited by SSISJoostMVP Sunday, November 30, 2014 1:55 PM
    • Proposed as answer by BI_Support Monday, December 1, 2014 5:22 AM
    • Marked as answer by Katherine Xiong Friday, December 5, 2014 12:07 PM
    Sunday, November 30, 2014 8:00 AM