SQL Server Performance

Row Count

Discussion in 'SQL Server 2005 Integration Services' started by danny123, Jul 16, 2008.

  1. danny123 New Member

    Hi there,
    I have to create a SSIS package for following task:
    1. Check the record orderShipped table and find out the records marked as Shipped.
    2. Flagging those records as disabled in the customer table.
    3. Flagging all the orders from that particular customer as shipped.
    I am using 2 separate Execute sql tasks to perform these 2 tasks. Now i was to see how many customers are disabled duing these 2 Execute SQL tasks. Now i have following questions:
    1. How can i use row count in this case to get the number of customers porcessed.
    2. Is there any better way to do this other than using Execute SQL Task.
  2. ndinakar Member

    What you are doing is a very simple and basic task. I dont think you even need SSIS for this.. you could just write the script and execute it from a job or create a proc and call it from the job..there are N number of ways of doing it...
    You can use @@Rowcount right after the update to get number of rows affected..
  3. danny123 New Member

    Thanks for the response.
    Well i know that i can do it as stored procedure and the call it from job, but i am doing it in SSIS to get some hands dirty on SSIS with initially easy tasks and get familier with things.
    So is there any suggestion about my doubts?

Share This Page