executing dmx query (prediction join) in ssis does not process all rows, works in SSMS
I run a prediction join (dmx query) against a table of 490K rows; it works fine in SSMStudio. Then I created an SSIS package to run the same query and it consistently stops at 18018 rows processed. Am I running up against some type of limit in SSIS? It's using a 'MS ole db provider for Analysis Services 9.0' connector in the ole db source, the ole db destination is a db on same server, the table gets the 18,018 rows inserted okay. I get the exact same problem with a larger (1.2 mill rows) table as input, also stops at 18,018 rows.
ss2005 9.0.1187
I chgd connection to timeouts of 0,space, 1000, 60000, and still had 18,018 rows returned from dmx query.I then tried to preview query and got following timeout: error:
===================================
There was an error displaying the preview. (Microsoft Visual Studio)
===================================
XML for Analysis parser: The XML for Analysis request timed out before it was completed. (Microsoft OLE DB Provider for Analysis Services 2005)
Program Location:
at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Connections.SQLTaskConnectionOleDbClass.ExecuteStatement(Int32 resultType, Boolean isStoredProc, UInt32 dwTimeOut)
at Microsoft.DataTransformationServices.Design.PipelineUtils.ShowDataPreview(String sqlStatement, ConnectionManager connectionManager, Control parentWindow, IServiceProvider serviceProvider, IDTSExternalMetadataColumnCollection90 externalColumns)
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowConnectionPage.previewButton_Click(Object sender, EventArgs e)
If I restrict the rows returned in the query to < 60,000, the preview works fine. Thanks for any help, comments.
