Hello Experts , i shared my solution that works fine for my business need  but i explain it to ou example SampleData :

DECLARE @StartPeriodLast2Months DATETIME = DATETIMEFROMPARTS(YEAR(DATEADD(MONTH,-15,GETDATE())),MONTH(DATEADD(MONTH,-15,GETDATE())),1, 0, 0, 0,...

the problem is solved with IR SSIS  following this link about customized install in IR

https://docs.microsoft.com/en-us/azure/data-factory/how-to-configure-azure-ssis-ir-custom-setup

my main.cmd script works very well, it was the missing file that I added...

• This reply was modified 2 years, 7 months ago by  ahmed_Tala.

Thanks Phil for your comments and help , I'll search more for a solution.

I think it'll be a simple modification in my cmd code (or powershell code)  OR the code...

also I see these links about install dll files with powershell to run my ssis package in server (located in Azure) , but still error : renci dll not installed...

• This reply was modified 2 years, 7 months ago by  ahmed_Tala.
• This reply was modified 2 years, 7 months ago by  ahmed_Tala.

Hello Phil ,

Really i'm writing to say "Many thanks" for you : So the problem is sloved in Desktop , it's a DLL files that should be installed in the...

Hello Phil, how are you . thanks for your post : it's helpful !

The syntax seems to be correct in C# (script task) when i follow the steps shown in...

Hello Phil,

thanks for answer. I have 2 mains errors :

1- on my code c# i have this error :  not identifing this class , i see videos how to add...