hi All, i am trying to load data from FoxPro to SQL 2005 using SSIS. i have created package for this and created >net ODBC connection for this. when i try to transfer data using data flow i am getting following error, Any work around please , as i tried change output column length , but it's throwing me an error stating can not change output column setting. this column contain numeric data from foxpro and going to decimal data type in sql 2005 Error: 0xC02090F8 at Data Flow Task, Source - Query [1]: The value was too large to fit in the output column "orders" (112). Error: 0xC0209029 at Data Flow Task, Source - Query [1]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Source - Query" (1)" failed because error code 0xC02090F8 occurred, and the error row disposition on "output column "orders" (112)" 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: 0xC02090F5 at Data Flow Task, Source - Query [1]: The component "Source - Query" (1) was unable to process the data. Error: 0xC0047038 at Data Flow Task: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02090F5. 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: 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: 0xC0047039 at Data Flow Task: SSIS Error Code DTS_E_THREADCANCELLED. 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. There may be error messages posted before this with more information on why the thread was cancelled. Error: 0xC0047021 at Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited. Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DF at Data Flow Task, Destination - xxx [175]: The final commit for the data insertion has started. Information: 0x402090E0 at Data Flow Task, Destination - xxx [175]: The final commit for the data insertion has ended. Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - xxx" (175)" wrote 28309 rows. Task failed: Data Flow Task SSIS package "Package1.dtsx" finished: Failure.

If I remember right, the numeric datatype in FoxPro is larger than the decimal thus you need a Derived Column Transformation to convert the incoming column to the appropriate datatype and or may be if the value is so large modify the destination field or trim the offending value.Arthur My Blog

i Increased the column property to decimal(12,2) for this, as foxpro has numeric(10,2) which can either hold 1234567890 or 12345678.90, so accordingly i have changed in sql to hold this value and set to decimal (12,2). though it is failing. i am just wondering , when SSIS creates Output columns it actually uses source output column definition or use sql server data types. if you check in datasource in dataflow, and go to advanced editor --> input and output properties -> external columns are source table property and output column is what is going to destination object. i can not change property for output column, here. any help on this.