November 27, 2007 at 2:49 pm
I am transferring data from one table to another in an SSIS package. How can i ensure that the total number of data extracted is equal to total number of rows data inserted. I am using OLD DB source and OLE DB destination. Do i even need to ensure this or no?.. i did add a row count inbetween them when in development just to make sure that all the data was being transferred and so far it was.. can someone guide me how i should go about this please...
November 28, 2007 at 1:35 am
I think if your package does not generate any error then all record are successfully transferred from source to destination (assuming there is not no additional logic between source and destination) and there is no empty handlers for errors and source and destination components has not set "ignore failure" option for error output.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply