Showing posts with label mining. Show all posts
Showing posts with label mining. Show all posts

Sunday, February 12, 2012

Cannot run Datamining query task in standard edition of Integration Services

Hi

We are using SQL Server 2005 Standard Edition. I have SSIS package which uses 'Data Mining Query Task'. I am using this task to run the predictions using the mining model I have deployed. When I run this SSIS package from IDE , everything is fine. But I deployed this SSIS to msdb, and when I right click on the package and run it from MSDB I get error message saying ,

'Cannot run this task in this edition of Integration Services. It requires higher level edition'.

Altimately we want to execute this SSIS from an API which is written in C#. Can you please suggest any workaround for doing so?

Thanks,

Vikas

You should be able to use the Data Mining Query Task in SQL Server Standard Edition - the Data Mining Query Transform is only available in Enterprise Edition. This may be an issue with running from msdb - I'm assuming the DB server is SE and not Workgroup or Express?

Regarding running a package stored in a DB from C#, please ask on the Integration Services forum.