Is it a Compatible bug in SQL Server 2005 ?

Hi, all here,

I use SQL Server 2005 standard edition ,

I choose to use table(table stored in Oracle9i) as source for mining structure, and I use

Oracle Provider for OLE DB(or Microsoft OLE DB Provider for Oracle).I set one column as logic key and this column stored chinese data.Deployment was successful. When I processed the mining structure,

an error happened:

Warning 0x80202066:Data Flow Task :Connot retieve the column code page info from OLE DB provider.If the comopenent 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.

But I created the same mining stucture and processed it successfully in SQL Server 2000. Is it a Compatible bug in SQL Server 2005？

It looks like the OLE DB provider for Oracle requires a code page to be specified because there is locale-specific (Chinese) data in the column.

There is a similar posting on the SSIS forum which you may find useful:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=2&SiteID=1&PostID=107027

HTH,

Akshai

|||

hi,Akshai,

thanks!

I had modified the Propertie:CheckDistinctRecordSortOrder in my SSAS,

and the mining model had been processed successfully!