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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-08-01 : 13:20:35
|
| hey Guys,I was using import/export wizard to load a flat file with comma delimiter with 2.4 billion records.. seems like data got loaded now sure if full data got loaded BUT this is the error I got..- Copying to [DBName].[dbo].[TableName] (Error)MessagesInformation 0x402090de: Data Flow Task: The total number of data rows processed for file "N:\fileName.txt" is 2180171755. (SQL Server Import and Export Wizard) Information 0x402090df: Data Flow Task: The final commit for the data insertion has started. (SQL Server Import and Export Wizard) 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: "Unspecified error". (SQL Server Import and Export Wizard) Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended. (SQL Server Import and Export Wizard) Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - TableName" (38) failed with error code 0xC0202009. 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 0xC0202009. There may be error messages posted before this with more information on why the thread has exited. (SQL Server Import and Export Wizard) |
|
|
|
|
|
Sql 2005 Import/Export Wizard