I downloaded the Delimiter File Read and followed the instruction and installed it. The file is on the correct directory (>:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents) The file DelimitedFileReader.dll is there. However, when I go to BI Development Studio and try to add the new task I can't see it in the SSIS Data Flow Items...it is not visible. Does anyone know why I can add/see it? ThanksKajoo

what is your problem with Flat File Source? why you used third party tools?http://www.rad.pasfu.com

The problem is that the flat file is erroring out because something is missing or is extra in one of the rows...The Delimited File Reader Task is deisgned to locate the rows that cause the error ThanksKajoo

you can use Flat file source and configure it with your flat file, you should use Error Output tab in flat file source editor , and then redirect BAD rows to any other transformation you want or ignore them. this is much better than using third party tools.http://www.rad.pasfu.com

I am using a Flat File Source. So I followed your advice and set the Error Output Tab in the Flat File Source Editor and then reset all the columns to Redirect Rows on Error but it is still failing. Please note that I created a table for the redirected erros..I am getting the same error as before...Any ideas why? ThanksKajoo

what is your error type? is it compile time error? or run time error? could you paste your error message here exactly?http://www.rad.pasfu.com

[Flat File Source [1]] Error: The column data for column "Imme Ca A" overflowed the disk I/O buffer. Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202091. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled. ThanksKajoo

what did you set as Row Delimiter? set it with CR/LFhttp://www.rad.pasfu.com

I am using a Foreach Loop to loop through all the flat files and the Row Delimiter is set as {CR}{LF}. The Flat File Source Task is working on all the flat files except one...in which it has something wrong with one of the rows. Thanks Kajoo

could you address the BAD file in flat file source directly and go in columns tab in flat file source editor and hit refresh and check what's wrong there?http://www.rad.pasfu.com

I opend the file in Flat File Connection Manager Editor and I am able to preview the data...however, I can only view the first 200 or so records and my flat file has more than 80,000 records. ThanksKajoo

I'm wondering of why redirect error failure don't work in this situation. didn't any rows inserted in the table which you redirect error output there?!!!http://www.rad.pasfu.com

No...no rows were redirected..Kajoo

Now going back at my original question, listed below, do you know why I am not seeing the SSIS Data Flow Task after installing it and restarting the computer? I downloaded the Delimiter File Read and followed the instruction and installed it. The file is on the correct directory (>:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents) The file DelimitedFileReader.dll is there. However, when I go to BI Development Studio and try to add the new task I can't see it in the SSIS Data Flow Items...it is not visible. Does anyone know why I can add/see it? Thanks,Kajoo

Hi Kajoo, Are you talking about SSIS Delimited File Source? If so, the assembly is "DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008.dll", not "DelimitedFileReader.dll". So, please make sure you have downloaded the correct version of the custom component. You can download and install it again from: http://ssisdfs.codeplex.com/ Additionally, please make sure the component is added to the toolbox manually: Right-click the toolbox and then click Choose Items. In the Choose Toolbox Items dialog box, click the SSIS Control Flow Items tab for a task, or the SSIS Data Flow Items tab for a data flow component. Click the check box next to your component(In this case, it is "DFS 2008"), and then click OK. For more information, please see: Building, Deploying, and Debugging Custom Objects: http://msdn.microsoft.com/en-us/library/ms403356.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Thanks! I will try it!Kajoo

do you mind sending me the file to have a look? rajsudeep<at>gmail<dot>com the one that errors out Tweet me..

Thanks for the help. But sorry guys, I can't send the files as they are confidential. Thanks!Kajoo