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 |
|
billbunting
Starting Member
3 Posts |
 Posted - 2009-05-19 : 16:56:21
|
| I am receiving the following error previously posted here, using SSIS to attempt to export data from an AS400 running DB2 to my SQL 2K5 machine.""Warning 0x80202066: Data Flow Task: 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"Does anyone know what this is and what to do about it? With much appreciation, Bill |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-20 : 04:40:22
|
| Yeah, it means the collation is different between the two. If the Data is looking OK, you can probably ignore this message, if the data doesn't look OK, you will need to find out how to change the codepage on your linked server. |
 |
|
|
billbunting
Starting Member
3 Posts |
Posted - 2009-05-20 : 09:51:30
|
| Hi RickD,I'm not getting any data at all, it looks like it's running, it's not crahing but it isn't returning data either. Any ideas?And thanks a bunch for your help....Bill |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-20 : 10:15:20
|
| As I said, look on the AS400 provider in your providers list under linked server. There may be a collation or codepage attribute (not sure as not sure which provider you are using).Also look under the properties of the linked server itself, there should be a collation compatible attribute here, try it on or off. If not, you will need to find a provider that will work, I know this is a pain as I had to do the same for Sybase 64 bit a little while ago, you may have to go as far as contact the providers to find a way around this if there is nothing on google. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-20 : 11:00:06
|
| Using the Microsoft DB2 OLEDB provider, I can use the following connection string in a linked server:Provider=DB2OLEDB;User ID=user;Password=password;Initial Catalog=dbname;Network Transport Library=TCP;Host CCSID=37;PC Code Page=1252;Network Address=server;Network Port=446;Package Collection=library;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/AS400;Defer Prepare=False;Rowset Cache Size=0;Persist Security Info=True;Connection Pooling=True;Derive Parameters=False;Just replace the red portions with the correct info and see if it works. The blue portion is the entry for code page/collation. |
|
|
|
billbunting
Starting Member
3 Posts |
Posted - 2009-05-20 : 19:23:32
|
| Thanks a bunch everyone, I'll give that connect string a whack and see what happens.....Stay tuned :) |
|
|
|
|
|
|
|
|
AS400 data retrieval error SQL 2K5 & DB2