Post reply

Run a SQL 2005 job from my SSIS package

  • January 4, 2008 at 2:13 pm

    #123098

    Hello everyone,

    I hope this exists. I would think it does, but can't seem to find the proper SSIS task. Here goes:

    I want to run a SQL Server Agent Job using one of the SSIS tasks. I just don't know which task to use to accomplish this. Execute Process looks the closest, but it doesn't do it. Anyone know how to run a SQL job using SSIS?

    I'm using SQL Server 2005 and SSIS

    Thanks,

    Strick

  • January 4, 2008 at 4:21 pm

    #765002

    Hello,

    Ok, I didn't notice the Execute SQL Server Agent Job Task. Looks like this will execute a SQL job. My question now is how would I go about doing this dynamically? There are some parameters in my package which determins which job needs to run and saves the job name to a variable in the package. This is the job that needs to run. Normally, I know I can go to Expressions and set a property = to my variable. However, I don't see a property in expressions called "jobname". Anyone know how I can go about doing this?

    Thanks,

    Strick

  • January 5, 2008 at 5:16 am

    #765060

    Use the property "AgentJobId"

    Peter

  • January 5, 2008 at 7:01 am

    #765066

    Great thanks. I noticed that one. So JobAgentID property actually representts the name of the job?

    Thanks,

    Strick

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

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