December 24, 2007 at 2:22 am
Hi Pals,
Here is my scenario in my ETL process, I have one DataFlow task.
Assuming that i have 10 clean records in my source database and i need to load all the 10 recs into my target table.
IS there any means of cross checking the no of rows from source table and number of rows loaded into my target table.
Any suggestions are greatly appreciated.
Thanks & Regards.
December 24, 2007 at 12:16 pm
Plenty of options and help at: http://www.sqlis.com
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 26, 2007 at 7:55 am
Do we have any specific example on this? If so what transformations / tasks can be used for this?
Thanks.
December 26, 2007 at 10:06 am
SQLIS has plenty of examples for all types of transformations. You might want to take a look at the rowcount transformation examples.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2007 at 8:05 am
Thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply