sql server dts: How can I get @@ROWCOUNT of a Transform Data Task -- sql server dts

How can I get @@ROWCOUNT of a Transform Data Task

Geri Reshef
6/20/2007 4:18:28 AM

sql server dts:

I'm importing a text file into a table using the DTS Transform Data
Task.
How can I get the number of the imported records?
The global variable @@ROWCOUNT is equal to 0 in the next step (Execute
SQL Task)..

Re: How can I get @@ROWCOUNT of a Transform Data Task

Merwin O. Pingul
6/22/2007 12:00:00 AM

Use rowcount blocking control with in the SSIS

[quoted text, click to view]

Re: How can I get @@ROWCOUNT of a Transform Data Task

rshivaraman NO[at]SPAM gmail.com
6/22/2007 8:41:37 AM

What i do, is after inserting in a table, i do a SELECT COUNT(*) FROM
TABLE
Where are you importing it into? Can you get a count from there ?

Ofcourse, this will only give a count of successfully imported rows
and not on the original source.

Let me know if you find an answer, as i would need to do the same

Thanks
RS

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.