Post reply

Run SSIS package using a stored procedure which runs every 1 hr

  • November 25, 2009 at 3:22 pm

    #140212

    How do I Run a SSIS package using a stored procedure which runs every 1 hr (using a job in sql enterprise manager ) or without using the job .

    Thanks

  • November 25, 2009 at 3:58 pm

    #1084399

    sqlserver12345 (11/25/2009)

    How do I Run a SSIS package using a stored procedure which runs every 1 hr (using a job in sql enterprise manager ) or without using the job .

    Thanks

    It is quite easy to get confused, can you clear this for me.

    Using stored procedure a SSIS package has to be run and the stored procedure runs every 1 hr.

    OR

    You need to run the an SSIS Package which uses a stored Proc and this Package has to run every 1 hr.

    Whatever it is, if you want to run it every 1 hr without using a job, it needs to be executed manually every one hour. Is that something you would be willing to consider?

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

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

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