Integration Service fails
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 of the lines.
Does anybody know other posibilities how to find out what data rows may cause the problem? Or how to view ALL lines in the DataViewers?
Hope somebody can help me...
thx in advance.
Re: Integration Service fails
Need more information. Can you please be more brief?