How to call a SSIS job from another SSIS job

Question

Post reply

How to call a SSIS job from another SSIS job

pattnaik.nandikesh

Old Hand

Points: 300
More actions
June 13, 2010 at 10:26 pm

#147492

Hi,
In my project i have a SQL server agent job which executes a SSIS package . Once the job completes successfully i want to call another SSIS job automatically. How can i do that.

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

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

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 1

I would add a second step to the job that called the first package.

CEWII

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 2

Add a second step in your first job. There, you can use T-SQL with a stored procedure to call the other job:

USE MSDB;

GO

EXEC dbo.sp_start_job N'My other job'

GO

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 3

[font="Comic Sans MS"]

Or you can add 'execute package task' (pointing to 2ng ssis package) in the first ssis package which will run on success of the end task of first package.

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

AmolNaik SSCarpal Tunnel Points: 4767 More actions · Answer 4

I like the idea of kicking off a separate job using T-SQL step in the Job. This makes it easy to re-run in case of the package failure. You just need to execute the step that failed.

Thanks,

Amol Naik

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 5

These are all valid methods that I would use.

Personally have each package in seperate job steps in order, if a step fails then fail the job.