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 |
|
JJins
Yak Posting Veteran
81 Posts |
 Posted - 2011-03-16 : 14:51:49
|
| How can I make this code export? Below is what I got in my first attempt.Code I used:SELECT Territories.*FROM Territorieswhere companyid = 4order by stateError I got:Validating (Error)Messages• Error 0xc02020f6: Data Flow Task: Column "State" cannot convert between unicode and non-unicode string data types. (SQL Server Import and Export Wizard) • Error 0xc02020f6: Data Flow Task: Column "County" cannot convert between unicode and non-unicode string data types. (SQL Server Import and Export Wizard) • Error 0xc02020f6: Data Flow Task: Column "Territory" cannot convert between unicode and non-unicode string data types. (SQL Server Import and Export Wizard) • Error 0xc004706b: Data Flow Task: "component "Destination - Query" (37)" 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) |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
|
|
|
|
|
Export