dbTalk Databases Forums  

Bulk Insert TSQL in DTS – Rows Affected Count

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Bulk Insert TSQL in DTS – Rows Affected Count in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SJM
 
Posts: n/a

Default Bulk Insert TSQL in DTS – Rows Affected Count - 09-06-2005 , 04:17 PM







I have a TSQL bulk insert command in a DTS package as an Execute SQL
Task because I need to have triggers fired on the table as the data is
inserted. I wish to know if there is a way to have the total number of
rows inserted to be returned so I can put it in a variable? I was hoping
this would be stored in msdb.sysdtssteplog as progresscount but it is
not.

I am interested in comments and/or suggestions.


*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.