I have one question in mind. I have created package that extract data from sql table and populate in flat file. I used OLEDB source and flat file destination. Now, I have executed the package. Source tabled has millions of record. After the completion
of package, I want to make sure that all rows from table has been loaded into the file and none of the rows are missed. source table has millions of record. How can i check that in SSIS? It doesn;t make sense to check every row in a file and compare
with source. So, How can i do that??
View Complete Post