Rowcount in log file in SSIS2008

Question

Post reply

Rowcount in log file in SSIS2008

Aarathy

SSC-Addicted

Points: 471
More actions
August 24, 2010 at 2:33 am

#141757

Hi,
I used task script component(Control flow task) to capture rowcount (no. of records inserted into destination)in logging file.
My question is which will be better in performance wise, adding script task in Data flow task or adding script component in Control flow task.
If adding in data flow task is better I need steps/code to perform logging.
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246988 More actions · Answer 1

Why not just use the Row Count transformation?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Aarathy SSC-Addicted Points: 471 More actions · Answer 2

Hi,

I use Row count transformation and get row count in a variable. I need this variable to be logged in log file for later verification.

So let me know if this is possible without a script task to log in log file?

Thanks.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

You can just insert the variable in the log with a simple SQL INSERT statement.

Or, you can write OnInformation events to the log and extract the numbers there.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Aarathy SSC-Addicted Points: 471 More actions · Answer 4

Can u pls. detail me the steps involved.

Performance perspective which would be better?

1. Using script task

2.Using script component

3. using insert SQL

4.Using event handler

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

The event handler will only be fired on specific events, and even if you go with the event handler, you still have to choose between SQL or VB.NET scripting 🙂

I would use the Execute SQL Task. Just map the variable to a question mark in your statement. It is fast, simple and easy to understand for developers who will inherite the package from you in the future.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Aarathy SSC-Addicted Points: 471 More actions · Answer 6

Hi,

I just want the rowcount to be captured in log file(.txt file) for reference. So in this case,my execute SQL will not fit in. Right?

Thanks.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

Aarathy (8/24/2010)
Hi,
I just want the rowcount to be captured in log file(.txt file) for reference. So in this case,my execute SQL will not fit in. Right?
Thanks.

Ah OK. I thought the log was a table in the database.

If it is a .txt file, you can use the script task (not the script component, the script task is better in just doing one thing, while the script component will be executed for each row) or a flat file destination.

I would go with the script task.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP