• Update - It looks like I was able to get the correct syntax:

    If Row.CommentsClean.ToString.Contains(vbLf) Then

    Row.CommentsClean.ToString.Replace(vbLf, "")

    Else

    Row.CommentsClean = Row.CommentsClean

    End If

    but now I get this, any help anyone?:

    SSIS package "_Export.dtsx" starting.

    Information: 0x4004300A at _Information, DTS.Pipeline: Validation phase is beginning.

    Information: 0x40043006 at _Information, DTS.Pipeline: Prepare for Execute phase is beginning.

    Information: 0x40043007 at _Information, DTS.Pipeline: Pre-Execute phase is beginning.

    Information: 0x402090DC at _Information, Flat File Destination [4826]: The processing of file "\\server\share\_Info.txt" has started.

    Information: 0x4004300C at _Information, DTS.Pipeline: Execute phase is beginning.

    Error: 0xC0047062 at _Information, Script Component [4935]: Microsoft.SqlServer.Dts.Pipeline.UnsupportedValueTypeForTextStreamColumnException: The value being written to DT_TEXT or DT_NTEXT column is not a string or an array of bytes.

    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)

    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)

    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)

    Error: 0xC0047022 at _Information, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Script Component" (4935) failed with error code 0x80131600. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

    Error: 0xC0047021 at Practice Information, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0x80131600. There may be error messages posted before this with more information on why the thread has exited.

    Information: 0x40043008 at _Information, DTS.Pipeline: Post Execute phase is beginning.

    Information: 0x402090DD at _Information, Flat File Destination [4826]: The processing of file "\\server\share\_Info.txt" has ended.

    Information: 0x40043009 at _Information, DTS.Pipeline: Cleanup phase is beginning.

    Information: 0x4004300B at Practice Information, DTS.Pipeline: "component "Flat File Destination" (4826)" wrote 0 rows.

    Task failed: Practice Information

    SSIS package "_Export.dtsx" finished: Success.

    -- Cory