Capturing Execution Results

Hi All

When running an SSIS Package from BIDS, we get to see the "Progress" tab which explains us the progress of the SSIS Package. During production, is there any way to capture this log. I am interested in using this as a log file for each run of my SSIS package.

Thanks,

S Suresh

Have you tried to enable logging in the package?

Thanks,
Ovidiu Burlacu

|||

I tried loging. But I want some Progress Reporting similar to one we see in the Execution Results. Any thoughts on this?

Thanks,

S Suresh

|||

Suresh S wrote:

I tried loging. But I want some Progress Reporting similar to one we see in the Execution Results. Any thoughts on this?

Thanks,

S Suresh

The information in the logfile is exactly the same as in teh Prgress tab.

|||

Suresh,

Just in case, here they are talking about package loging and not about SQL Server Agent loging. Package loging as it is being said, it will provide what you need.

Rafael Salas

|||

Hello,

I am not sure, I understand the difference between the two and would appreciate it if you could clarify how to implement package logging as opposed to SQL Server Agent Logging. I have enabled the package logging property, however, would like to obtain a file that is in the same format as that displayed in the 'Execution Results/Progress' tab.

Thanks,

Subah.

|||

Subah wrote:

Hello,

I am not sure, I understand the difference between the two and would appreciate it if you could clarify how to implement package logging as opposed to SQL Server Agent Logging. I have enabled the package logging property, however, would like to obtain a file that is in the same format as that displayed in the 'Execution Results/Progress' tab.

Thanks,

Subah.

You won't get a file that looks the same as that tab, but you WILL get a file with the same information (actually that's not strictly true - I know of one thing you get extra in the 'Execution Results/Progress' tab but its not something you need). It just won't be presented as nicely as it is in the 'Execution Results/Progress' tab, that's all.

-Jamie

|||Thanks Jamie. I guess I am on the right track then. :-)