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 |
|
Rach2009
Starting Member
37 Posts |
 Posted - 2010-02-26 : 05:43:31
|
| Hi All,I am getting an error out of the import wizard and not sure why.The query I am using is valid and parses ok, but when I try and preview the data and import nothing appears. I know there definitely is data there to import.The error message I get is:-Setting Source Connection (Warning) Messages * Warning 0x80202066: Source - Query [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used. (SQL Server Import and Export Wizard)Any ideas what this means?Many ThanksRachel |
|
|
namman
Constraint Violating Yak Guru
285 Posts |
Posted - 2010-03-07 : 12:15:53
|
| - Make sure your query works and returns correct data.- Make sure you select the right data sourceI think you will be OK. |
 |
|
|
|
|
|
Wizard Error