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.