I try to get the "Last modified" excel file in a folder and load it in SSIS. I found a C# code to get the name of most recent excel sheet in a folder path, and copy that in the Script Tas...

I have a SSIS package with a script task, I get the following error when i try to run it in my local system. It works fine for my collegues as well as in production. However, I am not able to run i...

I am trying to make Microsoft.Azure.Services.AppAuthentication and its dependencies work with SSIS script task. How do I resolve assembly reference errors? static ScriptMain() { AppDomain.Curren...

I am stuck with an error on Script Task in SSIS package. I could found similar questions but they are different from my scenario. Build the Script and which was failed with following error (for Err...

I have a very strange issue happening that is causing Script Task code to clear out. I have been able to test on 2-3 different machines. We are running SSDT 15.4 preview. The steps to reproduce wer...

Inside of a Script Task in SSIS, I need to make a call to an SQL database. I have a connection string that was created when I added the database to the data sources folder, however now I'm not sure...

I use EPPlus.dll library for generating Excel files on the fly for attachment and generate mailer in Script Task of SSIS package. When there is new requirement for change in mailer comes, I do the...

I have made the following PowerShell script: Set-Location D:\folder1\folder2\folder3\folder4; Get-ChildItem | Rename-Item -NewName {$_.BaseName.insert(19,'loadtime') + (Get-Date -Format HHmm) + $_....

How do you access a RecordSet variable inside a Script Task?