Hi all, How to check whether all the data loading into staging from flat files which are in shared drvie. Actually i am missing some data in staging tables. So i want to open my falt file and want to check . so that i can make that data is there in files but not loading properly. please let me know

Do you mean to say that you want to know the records that have not been loaded? Did you do any kind or error handling in the package? any logging for the error records? If not and you are interested in getting to know which records failed rather than why those records failed, you can pull the data form the flat file again sort it and merge it with the data loaded to the table and find the missing records.My Blog | Ask Me | Test your SSIS skills

Thanks Sudeep, Package got deployed already on prod server... evrythiing was fine previosly...now i got reliased that data is missing in our reports. so i did check in history and staging tables. No data available . but there should be some more data. So i want to check flat files whether data is there or not. how to check flat files or atleat no of records in flat file...so that i can check count in staging tables.

Hello, You can open your flat file with TextPad editor, then go to view and line Numbers, one you will click on that you will see how many lines of data you have at the bottom or can see the total number or lines by scrolling all the way down. Thanks http://sqlage.blogspot.com/

Jyo, I donot feel that you question is that you want to know how many records are there in the file? open the file in the notepad, remove wordwrap and select the option of status bar. ctrl+end will take you to the last line see the line number below and you have your answer. Hope you have the flat file with you. Few other questions: What is the frequency of the package run? When did you notice the mismatch in numbers? Is the data first loaded to staging table and then to prod? What happens to the source file? When the data is loaded to the prod table is there any time stamp added to the record?My Blog | Ask Me | Test your SSIS skills

Thanks Everyone. Exactly what i want is, i want to know whter all the data is loading correctly into Staging table from Flat files or not. Data first loading into Staging table and then production table. from there data will move into Details table after some manipulations and then Reports.

Have a data flowtask with the flat file source and rocount transform to get the count of records in file. Now connect this data flow to the existing data flow. In the existing data flow task have another row count transfom one before the oledb destination and one for error records. now in the control flow check if the row count initially mtches the count after the load & are thereany records in the error.My Blog | Ask Me | Test your SSIS skills