July 14, 2011 at 8:59 am
hi all
how many records we processed everyday in ssis
regards
July 14, 2011 at 9:08 am
Question does not make any sense, please elaborate if you want a answer.
July 15, 2011 at 12:12 am
If your question is:
"How to found out how many rows we processed today with SSIS?""
You need to set up logging to investigate that. The standard SSIS logging only logs the number of rows in informational messages, so that gives a big overhead if you log these. Furthermore, you'll need to parse the log message to find the actual number. There is some query on the interwebs that can do that for you. To the google!
A more efficient way to do this is to set up custom logging. You can use the Rowcount transformation to store the number of rows into a variable. Using another task you can log this to a table or file. Check out this blog post from Jamie Thomson: http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply