SQL DTS logging

There is nothing really built in to do that, either a custom Active X Task that has the same properties of a Transformation task but fills a table would help, or what I would try is to write an insert trigger on the table and add a counter to another table on every row inserted. Other then that you can get a log file reader and analyse your sql log file. There is possibly a way to read the transaction after successful import thus I am not quite sure how.

Gary wrote: Thanks Michael - it would have been nice if MS had included some "friendly" logging facilities in SQL.

thats MS for you! the simpsons epesode where homers compony is bought out my MS (broken to bits).. to save money, not pay him off..

that episode is a clasic example of here. save money don't make anlizers etc.