Suresh S


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




Re: Capturing Execution Results

Ovidiu Burlacu


Have you tried to enable logging in the package

Thanks,
Ovidiu Burlacu







Re: Capturing Execution Results

Suresh S

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






Re: Capturing Execution Results

Jamie Thomson

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.






Re: Capturing Execution Results

Rafael Salas

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






Re: Capturing Execution Results

Subah

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.






Re: Capturing Execution Results

Jamie Thomson

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






Re: Capturing Execution Results

Subah

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