Post reply

Schedule SSIS Package as a Job

  • April 18, 2006 at 10:42 am

    #113944

    I've create a SSIS Package and deployed it to my production sql server and am having trouble getting the package to run as a job.  I've created the package in the BI studio (runs fine there) and deployed the package to the target server. (runs fine there using the "Execute Package Utility"). However, when I try to schedule the package to run as a job it immediately fails.  My guess is that its a permissioning issue somewhere, but I'm new to SQL 2005.  Any help would be appreciated.  Thanks

  • April 18, 2006 at 2:55 pm

    #632967

    I answered your post on the SSIS forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=355435&SiteID=1

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • April 18, 2006 at 3:25 pm

    #632971

    Great! Thanks for your help.

  • July 9, 2009 at 6:44 am

    #1022311

    I too have a same problem as mentioned above. however when I try to schedule the job, it is done withour errors but the corresponding SSIS package is not executed. Even I am new to this SQl server 2005. I would appreciate your comments regarding this

  • July 9, 2009 at 6:45 am

    #1022313

    I too have a same problem as mentioned above. however when I try to schedule the job, it is done withour errors but the corresponding SSIS package is not executed. Even I am new to this SQl server 2005. I would appreciate your comments regarding this

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

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