SQL DTS logging
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12897
Printed Date: 30 March 2026 at 5:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL DTS logging
Posted By: Gary
Subject: SQL DTS logging
Date Posted: 09 December 2004 at 8:53am
|
Any suggestions on how to create an external log file (.txt) in which row counts can be inserted by the DTS?
eg A simple case would be the importing of data from a source table into a destination table. I want to write a log that will show how many rows have been imported.
Is this possible? Do I need to use some ActiveX code to do this & if so, how do I get the number of rows from the task?
Thx
|
Replies:
Posted By: michael
Date Posted: 09 December 2004 at 10:52am
|
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. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Gary
Date Posted: 09 December 2004 at 11:04am
|
Thanks Michael - it would have been nice if MS had included some "friendly" logging facilities in SQL.
|
Posted By: dj air
Date Posted: 12 December 2004 at 7:21pm
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. |
Gary wrote: