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. Thanks Danny
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..
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? Thanks Danny.
