CODEWITHSUNDEEP
ssis
Muhammad Sharjeel Ahsan
Muhammad Sharjeel Ahsan

Reputation: 672

Is there a way to find out which task is currently running in SSIS when running in SQL Server Agent job?

When I have to tell my boss how long it will take to finish the current SSIS package, I can get an estimate when the job is running in Visual Studio environment, but I'm totally blind when it's running using SQL Server Agent.

Is there any way to find out where the SSIS package is at a certain moment or which task is currently running at a certain moment?

Upvotes: 3

Views: 4745

Answers (2)

Bombays Blazer
Bombays Blazer

Reputation: 1

SQL 2014 shows running jobs in Service Catalog.

Example image

Upvotes: -1

Daryl Wenman-Bateson
Daryl Wenman-Bateson

Reputation: 3964

Creating your own log tables recording the steps that you are interested in works well if you are using SQL 2008 R2 (or earlier).

SQL 2012 has created a logging framework for you that will tell a host of information including the completed control flow steps. Within SSMS, look under Integration Services Catalogs and find your package. Right click and look under the Reports tab to get a detailed breakdown of past and current SSIS executions

Upvotes: 5

Related Questions