Post reply

How to create SSIS package ??

  • April 3, 2008 at 4:09 pm

    #188695

    HI Guys

    I have got a set of stored procedures and queries which i run each month for a particular project.

    HOw do I create a SSIS package which runs these stored procs and queries every month??

    Thanks

  • April 9, 2008 at 10:14 pm

    #800752

    If you already have the SPs created, you will save yourself a layer of complexity by just scheduling the SP to run using SQL Server Agent. You can use SSIS to do this, but you will basically just create a single-task SSIS package and set it up to run from an Agent job.

    hth,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • April 10, 2008 at 2:15 pm

    #801179

    Thanks for your help.

    Yes I totally agree

    Cheers:)

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

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