Could I Resolve a KPI's Data Value in a SSIS Script Task?

Hi, thanks.

I could rosolve a KPI's Data Value by ADOMD.net from any .net application. Now I want to do the same thing from the SSIS Script Task. Could I do that?

SSIS Script Task use a VBA Script. I could use ADO.net in it, by imports the XML.dll.

Thanks.

ivanchain wrote:

Hi, thanks.

I could rosolve a KPI's Data Value by ADOMD.net from any .net application. Now I want to do the same thing from the SSIS Script Task. Could I do that?

SSIS Script Task use a VBA Script. I could use ADO.net in it, by imports the XML.dll.

Thanks.

Yep. If its .Net then you can use it in a Script Task!

-Jamie

|||

But How? I don't know how to use any ADOMD.NET functions in SSIS Script Task. Because in the common VS, we need to imports the ADOMD.NET.dll into the projects if we want to use it. But in SSIS Script Task's imports list, I cound not find the ADOMD.NET.dll.

Anyone know this? Thanks!

|||

ivanchain wrote:

But How? I don't know how to use any ADOMD.NET functions in SSIS Script Task. Because in the common VS, we need to imports the ADOMD.NET.dll into the projects if we want to use it. But in SSIS Script Task's imports list, I cound not find the ADOMD.NET.dll.

Anyone know this? Thanks!

Aha. Yes, you're absolutely right. I should have realised this before - sorry.

Read this:

VSA requires DLLs to be in the Microsoft.Net folder (but not all the time)
(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2341.aspx)

-Jamie

|||Thanks, Jamie. You saved my life.