how to create a Log Files...?

Question

how to create a Log Files...?

Charmer

SSChampion

Points: 14903
More actions
December 12, 2011 at 5:33 am

#253282

Hi Friends,
well, In SSIS we get progress report about the execution through the Execution result...
i know this is hard..but all i need is i want to create log files for every execution in a separate folder in our local drive....
those log files must contain the details about why the process has gone failed..i mean the details about error records and the error columns and in which table....please i apologize if my question is stupid...because my need is like so...can any one help some links to get this done..? (program coding:C-sharp)...
Thanks,
Charmer

Viewing 15 posts - 1 through 15 (of 26 total)

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the log provider each time you run the package, probably with package configurations or with expressions.

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

Charmer SSChampion Points: 14903 More actions · Answer 2

Koen Verbeeck (12/12/2011)
You can use the standard built-in logging for that.
The only thing you need to do is change the connection manager for the log provider each time you run the package, probably with package configurations or with expressions.

k i understood to some extent..how to get the exact error records and error columns..and tables..?

does this make sense..?

Thanks,
Charmer

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
You can use the standard built-in logging for that.
The only thing you need to do is change the connection manager for the log provider each time you run the package, probably with package configurations or with expressions.
k i understood to some extent..how to get the exact error records and error columns..and tables..?
does this make sense..?

To log the exact error records and columns, you need to set-up custom logging and error handling. Out-of-the-box logging just tells you which component has failed and with which error.

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

Charmer SSChampion Points: 14903 More actions · Answer 4

Koen Verbeeck (12/12/2011)
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
You can use the standard built-in logging for that.
The only thing you need to do is change the connection manager for the log provider each time you run the package, probably with package configurations or with expressions.
k i understood to some extent..how to get the exact error records and error columns..and tables..?
does this make sense..?
To log the exact error records and columns, you need to set-up custom logging and error handling. Out-of-the-box logging just tells you which component has failed and with which error.

could you please show me how to go for custom logging...?

Thanks,
Charmer

herladygeekedness SSCertifiable Points: 5878 More actions · Answer 5

http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx

This link should get you started.

Phil Parkin SSC Guru Points: 246979 More actions · Answer 6

herladygeekedness (12/12/2011)
http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx
This link should get you started.

That's not a link. This is a link

😛

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
You can use the standard built-in logging for that.
The only thing you need to do is change the connection manager for the log provider each time you run the package, probably with package configurations or with expressions.
k i understood to some extent..how to get the exact error records and error columns..and tables..?
does this make sense..?
To log the exact error records and columns, you need to set-up custom logging and error handling. Out-of-the-box logging just tells you which component has failed and with which error.
could you please show me how to go for custom logging...?

I'm going to be a total *sshole here, but for pete's sake, learn how to use Google. (Or whatever search provider you prefer). This is not the first time that you ask very basic questions (nothing wrong with that perse) which can easily be solved by entering some keywords into Google and click "I'm feeling lucky". For example, the keywords "ssis custom logging" gives as first result the link to Jamie Thomson's old blogpost about custom logging, one of the best articles ever written about custom logging in ssis. (http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/1593.aspx).

We do not mind answering questions - that's why we are here - but we're not walking encyclopedias either...

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

Charmer SSChampion Points: 14903 More actions · Answer 8

Koen Verbeeck (12/12/2011)
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
Charmer (12/12/2011)
Koen Verbeeck (12/12/2011)
You can use the standard built-in logging for that.
The only thing you need to do is change the connection manager for the log provider each time you run the package, probably with package configurations or with expressions.
k i understood to some extent..how to get the exact error records and error columns..and tables..?
does this make sense..?
To log the exact error records and columns, you need to set-up custom logging and error handling. Out-of-the-box logging just tells you which component has failed and with which error.
could you please show me how to go for custom logging...?
I'm going to be a total *sshole here, but for pete's sake, learn how to use Google. (Or whatever search provider you prefer). This is not the first time that you ask very basic questions (nothing wrong with that perse) which can easily be solved by entering some keywords into Google and click "I'm feeling lucky". For example, the keywords "ssis custom logging" gives as first result the link to Jamie Thomson's old blogpost about custom logging, one of the best articles ever written about custom logging in ssis. (http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/1593.aspx).
We do not mind answering questions - that's why we are here - but we're not walking encyclopedias either...

i understood what were you saying...i was urged with this work and didn't have enough time....that's why i was expecting some good links from you guys instead of googling...

sorry if i made annoying you...

Thanks,
Charmer

Phil Parkin SSC Guru Points: 246979 More actions · Answer 9

For future info.

With the simple stuff, you should find it's faster to Google and use what's already been written than writing out a post and waiting for people to respond.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Charmer SSChampion Points: 14903 More actions · Answer 10

i am able to get the error columns as well as tables..but not able to get the exact error records...is this possible to get the records..?

Thanks,
Charmer

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 11

Charmer (12/13/2011)
i am able to get the error columns as well as tables..but not able to get the exact error records...is this possible to get the records..?

What do you mean with the exact error records? Do you mean the rows that cause the error?

If yes, add error handling to the component that causes the error and redirect to another destination. (using the red arrow)

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

Charmer SSChampion Points: 14903 More actions · Answer 12

Koen Verbeeck (12/13/2011)
Charmer (12/13/2011)
i am able to get the error columns as well as tables..but not able to get the exact error records...is this possible to get the records..?
What do you mean with the exact error records? Do you mean the rows that cause the error?
If yes, add error handling to the component that causes the error and redirect to another destination. (using the red arrow)

i know how to get the error rows inside the package.....but i need the error rows in the logging...logging gives me the tables and columns which gives error...but not rows...so i need rows too....

Thanks,
Charmer

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 13

Charmer (12/13/2011)
i know how to get the error rows inside the package ...
...
so i need rows too....

Euh. Problem solved?

That's the point of custom logging. If you handle the logging yourself, and you have the rows, you can log all you want about those rows.

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

Charmer SSChampion Points: 14903 More actions · Answer 14

Koen Verbeeck (12/13/2011)
Charmer (12/13/2011)
i know how to get the error rows inside the package ...
...
so i need rows too....
Euh. Problem solved?
That's the point of custom logging. If you handle the logging yourself, and you have the rows, you can log all you want about those rows.

Yes...i now understand how to create a custom logging separately in a .CSV file for every execution :satisfied:...but i am not able to get the error rows..

Thanks,
Charmer