Save Prediction Query Results to a SQL Table

Can anyone show me how to run a prediction query and save the results to a sql table without using the T-SQL OPENQUERY tip here http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3914.aspx? I am looking for an example in vb.net that I can use in a SSIS script task.

Thanks

I am having problems getting to the ADOMD.NET classes from a script task in SSIS. Can you even get to them from with in SSIS?|||

SSIS includes a data mining query transform (inside the Data Flow task), which can be used to execute data mining prediction queries against data from the pipeline. The results are passed down the pipeline and can be saved in a sql table. Using this query component does not require any additional coding.

A DM Query Task is also included in the set of tasks. A Data Mining query can be executed and the results can be saved directly into a relational table. This also does not require coding (but cannot be applied to data in a SSIS pipeline).

Does this solve your problem or you still need an example for using Adomd.Net in SSIS?

|||

Bogdan,

Thanks for the help. I am aware of the DM tasks in SSIS. However, am running into limitations. I am creating dynamic DMX queries in a Script Task and the query can often exceed the 4000 char limit of the SSIS string variable and can not be passed to the DM tasks via a varable and you can not get to those properties via code to assign the value that way. So I figured that the only way I would be able execute this query is if I was able to use Adomd.Net with in the same script task that I am creating the query in and then dump the results into a SQL table.

|||

Found out how to get to Adomd.Net from the SSIS environment but it is kinda a hack. You have to copy the assembly from the SDK folder to your GAC.
Using the standard install paths:
Copy
C:\Program Files\Microsoft.NET\ADOMD.NET\90\Microsoft.AnalysisServices.AdomdClient.dll
To
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Then run gacutil.exe" /i "C:\windows\Microsoft.NET\Framework\v2.0.50727\Microsoft.
AnalysisServices.AdomdClient.dll"
This will have to be done for any system running the SSIS code. You will also have
to re-copy when you apply a Hotfix or SP to your AS server.

I would still appreciate it if anyone could provide some sample code.

Cheers