Post reply

Multiple Tasks in SSIS Package

  • November 20, 2009 at 2:35 pm

    #156422

    Hi,

    I'm new to SSIS and I'm trying to accomplish a project at work using SSIS.

    1.Get the data from SQL server using stored procedures and populate the tables. The data will be same for all the feeds.

    2.Get the data from the tables and create flat files for different vendors.

    Do I need to create two packages to accomplish this? If I have to create two packages, can I run them in sequential order i.e. task 1 and then task 2. How will I be able to accomplish this.

    Let me know if you need any additional information. Pardon my SSIS lingo as I just started working on this product.

    Thanks,

    Prasad

  • November 20, 2009 at 2:50 pm

    #1082510

    You don't need to create 2 packages for this, you can have both of them in a single package.

    At this point, there is not much I can help on the SSIS packages you may need,

    since I don't have much details.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • November 20, 2009 at 2:52 pm

    #1082511

    A single package will do the job for you. An EXECUTE SQL task can be used to run the sp's. Followed by one or more dataflow tasks to export the data for you. Use precedence constraints to control the order in which the tasks are executed.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 20, 2009 at 3:01 pm

    #1082517

    Phil Parkin (11/20/2009)

    A single package will do the job for you. An EXECUTE SQL task can be used to run the sp's. Followed by one or more dataflow tasks to export the data for you. Use precedence constraints to control the order in which the tasks are executed.

    Hi Phil,

    Thanks for the response. I should be able to run multiple SQL statements in one EXECUTE SQL task right? I need to populate multiple staging tables. I'm planning to use stored procedures to populate the data in to the tables.

    Thanks,

    Prasad

  • November 20, 2009 at 3:18 pm

    #1082525

    Prasad Boppana (11/20/2009)

    I should be able to run multiple SQL statements in one EXECUTE SQL task right? I need to populate multiple staging tables. I'm planning to use stored procedures to populate the data in to the tables.

    Thanks,

    Prasad

    Yes you should be able to run multiple SQL Statements in 1 Execute SQL Task.

    Instead of using Stored Procedures, you can use the Data Flow task in SSIS which would give additional benefits of enabling checkpoints etc in the package.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • November 20, 2009 at 3:25 pm

    #1082532

    Thanks Bru and Phil. I appreciate your help. I will try that approach.

Viewing 6 posts - 1 through 5 (of 5 total)

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