Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import VFP 6.0 to SQL 2005
Message
From
22/03/2008 08:48:26
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Import VFP 6.0 to SQL 2005
Miscellaneous
Thread ID:
01304547
Message ID:
01304547
Views:
66
I need to import one table from VFP 6.0 database into SQL 2005 and got the following error
**I spend over 1hrs to scan the vfp tables and it seems valid, I don't know which record got the error . Please give me a hand

---------------------------------------
Messages
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: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].initname'. ".
(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: The ProcessInput method on component "Destination - companyheader" (259) 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.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0202009.
(SQL Server Import and Export Wizard)
Next
Reply
Map
View

Click here to load this message in the networking platform