Create a Job for Running SSIS package
Hi I have created SSIS packges and one Master Package to run them in a sequence. They work perfectly when I run the packages from BIDS. I tried to create a job in SSMS 2008. I have created a new job and in step I have added the Master package. When I execute the job, it says that the job is succeeded but doesn't actually run the packages. Please let me know what I am doing wrong here. Thanks MadhaviMadhavi Pasapula
July 18th, 2012 2:46pm

Have you enabled logging? If so, check your logs to see what exactly is happening? If possible, post the log details.Karthik
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 7:42pm

This could be due to handful of issues. Check the following Have you deployed all the SSIS packages on the server. If yes are you able to see them under MSDB. Have you tried enabling the job log in job -> properties -> edit step -> advanced tab -> Check the check box that creates a text log Are you trying to run BIDS and the job on the same environment. If not check the connection managers for access in different environments These are some of the top of the head items i can think of. Please update this thread with more details on the above three points to help us resolve your issue.NSK
July 19th, 2012 1:48am

if you want to run the packages sequentially using a SQL job, you may not need to have the Master package. in the SQL job, add steps for each ssis packages one by one with On Success, On Failure option. then in case there is some errors with some packages you can see in the see what is the cause in the job step itself in the "Job Activity Monitor" section. It is good to know some network or access related issues with job and packages. regards joon
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2012 3:59am

Hi Thank you for all the suggestions. I checked the Job monitor and they are on the same environment. I am not sure what the problem I deleted the job and created it again today and everything is working fine. Thanks Madhavi Madhavi Pasapula
July 19th, 2012 9:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics