Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BrianC
Starting Member
4 Posts |
 Posted - 2009-08-11 : 06:19:30
|
| I am getting this error text when trying to import a small test file to an empty database...any ideas as to what have I missed?Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". (SQL Server Import and Export Wizard) Error 0xc020901c: Data Flow Task: There was an error with input column "QTY_PICKED" (83) on input "Destination Input" (51). The column status returned was: "The value could not be converted because of a potential loss of data.". (SQL Server Import and Export Wizard) Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (51)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "Destination Input" (51)" 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. (SQL Server Import and Export Wizard) Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - BCSQL_Testing_Order_Lines" (38) 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. (SQL Server Import and Export Wizard) Error 0xc0047021: Data Flow Task: 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. (SQL Server Import and Export Wizard) |
|
|
cycledude
Starting Member
9 Posts |
Posted - 2009-08-12 : 10:09:23
|
| You have an overflow error: "The value could not be converted because of a potential loss of data.". Check the data type of the column in which QTY_PICKED is being loaded into. You probably need QTY_PICKED to be a 4-byte signed integer. When using SSIS, this can occur on any of the objects used on the Data Flow tab. It usually occurs on the OLE DB source object because the object samples the first few rows to determine the data type to use, and doesn't get it right. I've run into situations where I needed to concatenate dates with a null string to force the value being retrieved to a string that could then be parsed to determine validity of the date value. Some dates in 3rd-party systems and Access databases aren't valid in SQL Server. |
 |
|
|
|
|
|
IMPORTING A FLAT FILE (.CSV)