Hi,
I am executing my SSIS package from SQL Job. I placed the Log file in the D drive of the sever. After each execution the log is overwritten. But in the log i am not able to find
What are the table affected?
how many records have inserted into each table?
In SQLServer2000 logs i can able to find all these details. Its also showing process of execution.
Ex:-
1000 records have inserted
2000 records have inserted
3000 records have inserted
.
.
I need same log in SQL Server 2005.
Thanks.