question

MarkSeidelin-5973 avatar image
0 Votes"
MarkSeidelin-5973 asked ZoeHui-MSFT commented

SSIS Script task and DLLs and .NetCore

i have developed a simple ProofOfConcept WinForms app that uses Microsoft.AnalysisServices.NetCore.retail.amd64 to interact with SSAS to refresh a PowerBI dataset. works fine
(using .netCore 3.0)

am now trying to do the same in a script task in SSIS so we can refresh the PowerBI datasets as final step of doing the overnight ETL
but the framework package for the c# script is .NetFramework 4.7 - so compatability issues with the DLL used above
is it possible to change this so i can use the same .netCore3.0 DLL that i used before... if so, how ??

i have also tried using Microsoft.AnalysisServices.retail.amd64 (implemented via a NuGet package) but it fails with
Error: Could not load file or assembly 'Microsoft.AnalysisServices.Tabular, Version=19.22.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
that should work but the c# script seems to delete the DLLs from where the NuGet package puts them.

environment is VisualStudio Enterprise v 16.9.4, targeting SQLServer 2019



sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MarkSeidelin-5973,
As DanGuzman said that SSIS Script task doesn't support .NET Core and .NET standard assembly references.

0 Votes 0 ·

1 Answer

DanGuzman avatar image
1 Vote"
DanGuzman answered

No, you cannot use .NET core in SSIS script tasks as mentioned in the SSIS script task documentation:

Currently we don't support .NET Core and .NET standard assembly references.

You'll need to use a .NET framework implementation or a shared service if you want to use the same code.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.