Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Inconsitent flat file, how to find out the error

Author  Topic  lindner Starting Member 3 Posts Posted - 2010-06-11 : 07:28:17 Hey I am really new to MSSQL Server and Integration Services. I have to get to work some already build Integration Services that fetch data from a flat file putting it into a MSSQL DB. Actually this works very good with some old data flat files. Now I wanted the IS to import from newer files but somehow an error occurs. I didn't create those services and its quiet hard to debug it for me as a newbie. I get the following error: Row yielded no match during lookup. I understand the message but I don't know how to find out what information in the flat file causes that problem. The flate file has over 13000 entries that need to pass a certain dataset. But only 11000 entries will come out.. So I don't know which data is missing. Those 2000 rows may have something in common. Maybe the structure of the origin DB or of the flat file has changed - but I won't figure that out until I know which data I have to look at. I was reading some board entries here already, so found out that I could set some DataViewers before and after the taks. But these viewers won't show me the whole dataset. I only get a quarter or a half ot the lines. Does anybody know another posibilities how to found out what data rows cause the problem? Or how to view all the lines in the DataViewers? Hope somebody can help me... thx in advance. superman ;)