SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Logging in DTS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gv_pradeep
Starting Member

19 Posts

Posted - 08/19/2008 :  09:48:33  Show Profile  Reply with Quote
Hi,
I have a DTS where I have one Execute SQL Task.
I need to log the number of rows affected by this SQL task.
Logging Tab in Package Properties gives me very limited options.
Please let me know how i can achieve this.

Thanks.

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 08/19/2008 :  10:02:25  Show Profile  Reply with Quote

You have to use dynamic property task or Activexscript:

http://doc.ddart.net/mssql/sql2000/html/dtssql/dts_addf_ax_06er.htm
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000