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-07 : 10:33:44
|
| I know how to right click the instance and export data, but I have never experienced the errors listed below. Can anyone help me overcome these issues? THANKS! below the errors is the query.Best,GG Validating (Error)MessagesError 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) Error 0xc0024107: Data Flow Task: There were errors during task validation. (SQL Server Import and Export Wizard)------------------------------------------------------------------------------------------------------------------------------------------------AOP 500---Builders risk has a minimum of 2500 and Secondary Seasonal cant have credit for 1000SELECT RateData.*, Programs.*FROM RateData INNER JOIN Programs ON RateData.ProgramID = Programs.ProgramIDwhere programs.state = 'NJ' and programs.companyid = 2 and DCmax != 20 and ratedata.limitmax = 500 and ratedata.coverageid = 11 and programs.policytype in (1,2,5,6) ---1000 ---Builders risk has a minimum of 2500 and Secondary Seasonal cant have credit for 1000SELECT RateData.*, Programs.*FROM RateData INNER JOIN Programs ON RateData.ProgramID = Programs.ProgramIDwhere programs.state = 'NJ' and programs.companyid = 2 and DCmax != 20 and ratedata.limitmax = 1000 and ratedata.coverageid = 11 and programs.occupancytypeID != 2 and programs.policytype in (1,2,5,6) ---2500 Builders risk has a minimum of 2500 SELECT RateData.*, Programs.*FROM RateData INNER JOIN Programs ON RateData.ProgramID = Programs.ProgramIDwhere programs.state = 'NJ' and programs.companyid = 2 and DCmax != 20 and programs.occupancyTypeID != 6 and ratedata.coverageid = 11 and ratedata.limitmax = 2500 and programs.policytype in (1,2,5,6) order by limitmax |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-07 : 17:43:00
|
| Looks like the table on one side has a varchar column and on the other side it is nvarchar. Compare your table schemas. If you do want to export to even with different table schemas, use the "export from a query" option in the wizard and explicitly cast the columns. |
 |
|
|
JJins
Yak Posting Veteran
81 Posts |
Posted - 2011-03-11 : 09:50:52
|
| Thank you that was very helpfull!!best,GG |
|
|
|
|
|
|
|
|
export