troubleshooting Question

Error importing data into SQL 2008 R2 Express database..

Avatar of victordr
victordr asked on
Windows Server 2003Microsoft SQL Server 2008
16 Comments1 Solution3342 ViewsLast Modified:
I am trying to import data from a txt file into a SQL 2008 R2 Express databse using the import wizard and i am recieving the following errors.

- Validating (Error)
Messages
Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "COMPANY" with a length of 50 to database column "COMPANY" with a length of 30.
 (SQL Server Import and Export Wizard)
 
Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "CONTACT" with a length of 50 to database column "CONTACT" with a length of 30.
 (SQL Server Import and Export Wizard)
 
Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "PHONE" with a length of 50 to database column "PHONE" with a length of 30.
 (SQL Server Import and Export Wizard)
 
Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "FAX" with a length of 50 to database column "FAX" with a length of 30.
 (SQL Server Import and Export Wizard)
 
Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "Description" with a length of 50 to database column "DESCRIPTION" with a length of 30.
 (SQL Server Import and Export Wizard)
 
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "ID".
 (SQL Server Import and Export Wizard)
 
Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task 1: "component "Destination - VENDOR" (42)" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
 (SQL Server Import and Export Wizard)
ASKER CERTIFIED SOLUTION
victordr

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros