dbTalk Databases Forums  

DTSWizard Warming, when replicating the Data from AS400

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTSWizard Warming, when replicating the Data from AS400 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kam
 
Posts: n/a

Default DTSWizard Warming, when replicating the Data from AS400 - 02-14-2006 , 11:09 PM






I am using the OLE DB Provider for DB2 from Microsoft to extract the data
from AS/400 into SQL 2005.

But I received the warming in "Setting Source Connection", Validating and
Pre-execute phases.

- Pre-execute (Warning)
Messages
* 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.
(SQL Server Import and Export Wizard)

* 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.
(SQL Server Import and Export Wizard)

* 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.
(SQL Server Import and Export Wizard)


Can anyone tell me the correct CodePage that I should use for the AS400?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.