Dear Experts, if I am having 10000 records in flat file as source and moving it to an oledb destination and one of the recorded is truncated due to some error how can i find which record is truncated from source. karthikeyan

For finding out which record it is you can disable the fastload option in the destination and use an error output that redirects to a flat file destination. But disabling the fastload will make your package slower! Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I would agree with SSIS joost. You can configure error output in the datflow and redirect the truncated data to another destination. So you can find out which data would be truncated. Please find the link below it should help with additional information. http://msdn.microsoft.com/en-us/library/ms141679.aspxKeerthi Kiran

Another option is to load the data temporarily to a staging table that his wider columns. There you can use TSQL to find out which rows have records that exceeds certain lengths.MCTS, MCITP - Please mark posts as answered where appropriate.

use Configure Error Output as others said, for 10K records this won't cause Very Big load time. this is another sample of configure error output: http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.htmlhttp://www.rad.pasfu.com

ANother suggestion is 1 - REDIRECT the TRUNCATE records from the SOURCE object in your case it is a FLAT FILE (FF), use an extra field in the OLE destination (tblDES) table called TruncateFlag 2- after redirecting use a DERIVED COLUM and make a new field in it called "TruncateFlag" as set it to 1 or true, 3- use a UNION object to load the GOOD records from the FF Source and the BAD records from the Derived column 4- Use a OLE that gets feeded from the UNION and you can use FAST LOAD good luckSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

fine i can get only the error code is there any other way to get error description with out using scriptingkarthikeyan

fine i can get only the error code is there any other way to get error description with out using scripting karthikeyan I don't think so. But this blog post explains it in great detail: http://consultingblogs.emc.com/jamiethomson/archive/2005/08/08/SSIS-Nugget_3A00_-Get-error-descriptions.aspxMCTS, MCITP - Please mark posts as answered where appropriate.