Post reply

Import Export

  • May 31, 2010 at 11:35 pm

    #140633

    Hi

    I am facing a peculiar problem

    when I bulk export SQL table to flat file few records do not copy nd the export wizard terminates

    but when these rows are transferred they transfer to the flat file quiet conviniently

    error is following

    Messages

    Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "OtherInstitute1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

    (SQL Server Import and Export Wizard)

    Error 0xc02020a0: Data Flow Task: Cannot copy or convert flat file data for column "OtherInstitute1".

    (SQL Server Import and Export Wizard)

    Error 0xc0047022: Data Flow Task: The ProcessInput method on component "Destination - 26thMay20101_txt" (148) failed with error code 0xC02020A0. 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.

    (SQL Server Import and Export Wizard)

    Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC02020A0.

    (SQL Server Import and Export Wizard)

    Error 0xc02020c4: Data Flow Task: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

    (SQL Server Import and Export Wizard)

    Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - Candidates" (1) returned error code 0xC02020C4. 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.

    (SQL Server Import and Export Wizard)

    Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038.

    (SQL Server Import and Export Wizard)

    waiting for help

  • June 2, 2010 at 4:48 am

    #1175193

    Always try to keep column's name and their datatypes same.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • June 3, 2010 at 12:52 am

    #1175716

    Already tried these...

    no use :pinch:

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply