Showing posts with label structure. Show all posts
Showing posts with label structure. Show all posts

Wednesday, March 7, 2012

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!

Monday, February 20, 2012

Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,

Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,