Advertisement

05.20.2008 at 06:03AM PDT, ID: 23416934
[x]
Attachment Details

SQL Server 2005 Import Text File

Asked by lrbrister in MS SQL Server, SQL Server 2005

Hey guys,
Doing something that I've done thousands of times...importing a simple text file.  However...I keep getting a bomb out in the process...please see the error message below.


Error 0xc02020f6: Data Flow Task: Column "url" cannot convert between unicode and non-unicode string data types.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task: "component "Destination - rainmakers" (16)" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task: There were errors during task validation.
 (SQL Server Import and Export Wizard)
 
Start Free Trial
[+][-]05.20.2008 at 06:07AM PDT, ID: 21605721

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 06:12AM PDT, ID: 21605766

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 06:13AM PDT, ID: 21605773

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 06:14AM PDT, ID: 21605782

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 06:16AM PDT, ID: 21605798

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Server 2005
Sign Up Now!
Solution Provided By: pratima_mcs
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906