Parameterized Data Mining Query Task
This may seem pretty basic but it is driving me nuts!! How does one write a parameterized Data Mining Query task? I know you can map a variable to a parameter name on the parameter mapping tab. What I need to know is the exact syntax for getting that parameter into the DMX on the Build Query tab. This is my DMX: SELECT FLATTENED Cluster(), t.[AColumn], t.[AnotherColumn] From [MiningStructure] PREDICTION JOIN OPENQUERY([Jason], 'SELECT [AColumn], [AnoitherColumn] FROM ATable WHERE Table.Column = WHAT ON EARTH DO I PUT HERE') AS t I am running SQL 2008 SP2 and connecting using OLE DB Provider for Analysis Services 10.0 Thank you, Jason
December 22nd, 2010 3:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics