July 7, 2009 at 5:03 am
SSIS package "DIM_Test (1).dtsx" starting.
Information: 0x4004300A at Data Flow Task RIMGUIJ2, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task RIMGUIJ2, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task RIMGUIJ2, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task RIMGUIJ2, Flat File Source [1]: The processing of file "K:\FTP\FDB\Imprint\Drug Image DB\RIMGUIJ2_UNQ_DRUG_JRNL" has started.
Information: 0x4004300C at Data Flow Task RIMGUIJ2, DTS.Pipeline: Execute phase is beginning.
Error: 0xC0049062 at Data Flow Task RIMGUIJ2, Derived Column [925]: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.
Error: 0xC0209029 at Data Flow Task RIMGUIJ2, Derived Column [925]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (925)" failed because error code 0xC0049062 occurred, and the error row disposition on "output column "Derived Column 1" (946)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task RIMGUIJ2: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Derived Column" (925) failed with error code 0xC0209029. 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 Data Flow Task RIMGUIJ2: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC02020C4 at Data Flow Task RIMGUIJ2, Flat File Source [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Error: 0xC0047038 at Data Flow Task RIMGUIJ2: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (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. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task RIMGUIJ2: 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.
Information: 0x40043008 at Data Flow Task RIMGUIJ2, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task RIMGUIJ2, Flat File Source [1]: The processing of file "K:\FTP\FDB\Imprint\Drug Image DB\RIMGUIJ2_UNQ_DRUG_JRNL" has ended.
Information: 0x402090DF at Data Flow Task RIMGUIJ2, OLE DB Destination [42]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task RIMGUIJ2, OLE DB Destination [42]: The final commit for the data insertion has ended.
Information: 0x40043009 at Data Flow Task RIMGUIJ2, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task RIMGUIJ2, DTS.Pipeline: "component "OLE DB Destination" (42)" wrote 0 rows.
Task failed: Data Flow Task RIMGUIJ2
SSIS package "DIM_Test (1).dtsx" finished: Success.
If anybody can help me.
July 7, 2009 at 6:20 am
I think you are using the derived column to derive some columns.You also use data conversion transformation and convert the data type to required format and try it.
cheers
MSK Reddy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply