Saturday, March 10, 2012 7:50 PM
I have probably a silly question. I have a job in my sql agent. The job runs an SSIS package. The package works fine, I can see no free memory in task manager :), I can see the results, I can see it in the job monitor, but I cant see it in running packages in SSIS service? Why?
Sunday, March 11, 2012 6:45 AM
You can check status of the job if it has running status that means SSIS is running (Look up using [sp_help_job] in Books Online.)
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
- Proposed As Answer by Jerry NeeModerator Friday, March 16, 2012 8:40 AM
Sunday, March 11, 2012 5:43 PM
OK, thanks for the function. But it still means that I can not see all package in "running packages" list?