1. What is logging in SSIS , How many type of logging available in SSIS, Which one you have used
2. If you need to create a text type log file with timestamp, how you will do that
3. If you use SQL Server Logging, which table will be used to store log information
4. What are the few column names that sysssislog have to store log information
5. Do you log all the events or prefer to choose few of them?
6. Name few of Events you like to use in logging
7. What is custom Logging and how it is different from built in Logging
8. If you use timestamp in your text file logging , it creates multiple log files with each execution, how to avoid that and why single execution create more than one file
9. If we are using SQL Server Logging, how often the records got deleted from syssislog table or we have to create some purge process
2. If you need to create a text type log file with timestamp, how you will do that
3. If you use SQL Server Logging, which table will be used to store log information
4. What are the few column names that sysssislog have to store log information
5. Do you log all the events or prefer to choose few of them?
6. Name few of Events you like to use in logging
7. What is custom Logging and how it is different from built in Logging
8. If you use timestamp in your text file logging , it creates multiple log files with each execution, how to avoid that and why single execution create more than one file
9. If we are using SQL Server Logging, how often the records got deleted from syssislog table or we have to create some purge process
Good works man
ReplyDelete