InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 15:55:00 GMT20http://www.sqlservercentral.com/Forums/Topic1276362-2797-1.aspxsorry ,i am asking this question for month but unfortunately i donot get any answer for that .and i have to ask this question in others part of forums .Sun, 01 Apr 2012 10:16:27 GMTLarry Page(Ehsan.Akbar)http://www.sqlservercentral.com/Forums/Topic1276362-2797-1.aspxduplicate post. No replies plese.Please repond using the [b][url=http://www.sqlservercentral.com/Forums/FindPost1276358.asp]original thread[/url][/b]@Larry: Posting the same question multiple times does not only fragment the answers. It might also lead to duplicate answers (= waste of time for those of us answering questions).Sun, 01 Apr 2012 08:42:44 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1276362-2797-1.aspxI have a data base (testmining) with 2 tables in my engine service,these 2 table are connected with customer_id column as a primary key in customer and foreign key in purchaseand i have a database (mining) in my analyses service on my sql server 2008 ,so i create a mining model in my mining database on analyses services :Create mining model MarketBasketModel(CustomerId long key,Gender text discrete,Income long continuous,MemberCard text discrete,Purchases table Predict_Only (ProductName text key,Quantity long continuous))Using Microsoft_Decision_Treesso when i want to execute this command :Insert into MarketBasketModel_Structure( CustomerId, Gender, Income, MemberCard,Purchases( ProductName, Quantity) )OpenRowset('SQLOLEDB', 'Server=EHSAN-PC;Integrated Security=SSPI','Shape{ Select Customer_id, Gender, Income, member_cart From testmining.dbo.Customer }Append ({ Select Product_Name, Quantity From testmining.dbo.Purchase }Relate testmining.dbo.Customer.Customer_Id to testmining.dbo.Purchase.Customer_id ) as Purchase')i got this error :OLE DB error: OLE DB or ODBC error: Syntax error or access violation; 42000Sun, 01 Apr 2012 08:36:32 GMTLarry Page(Ehsan.Akbar)