Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    7

    Unanswered: SSIS: ETL import data error

    have tried to import data from a big (257Mb, I has about 1.000.000) flat file into a table, inside SSIS. The process doesn’t work correctly. It stops in the same register (about 179.000). I have reviewed the process and have opened the file making it shorter (about 150.000 lines, including the line that before seems to break the process), and it works. Making the file longer it breaks the process again.



    The error showed by the program:



    Error: 0xC02020A1 at Data Flow Task, Flat File Source [2820]: Data conversion failed. The data conversion for column "debe" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

    Error: 0xC0209029 at Data Flow Task, Flat File Source [2820]: The "output column "debe" (4066)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "debe" (4066)" specifies failure on error. An error occurred on the specified object of the specified component.

    Error: 0xC0202092 at Data Flow Task, Flat File Source [2820]: An error occurred while processing file "Z:\PROYECTOS IT\Soluciones de negocio\Proyectos\SANDO\Proyecto 5. Codificación\ETL\capun00108.unl" on data row 36804.

    Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "Flat File Source" (2820) returned error code 0xC0202092. 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.

    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

    Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.



    Anybody knows what could be happening?

    Any help would be very appreciated



    Thanks



    PD: I mean that it´s not a date format problem (I have reviewed some post talking about it)

  2. #2
    Join Date
    Dec 2005
    Location
    Tilburg, Netherlands
    Posts
    73
    Maybe you want to try the good old BCP command line program to import a bunch of data. It never let me down ... so far. Even on bigger files than you mention.

    Gr,
    Yveau

    > SELECT * FROM users WHERE clue > 0;
    Empty set (0.00 sec)


  3. #3
    Join Date
    Dec 2006
    Posts
    7
    Thanks i'm going to try it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •