Top "Script-task" questions

Connect to SQL database inside Script Task in SSIS

Inside of a Script Task in SSIS, I need to make a call to an SQL database. I have a …

c# sql sql-server ssis script-task

"Runtime error Exception has been thrown by the target of an invocation" from Script task

I have a SSIS package with a script task, I get the following error when i try to run it …

c# ssis script-task

SSIS - How to access a RecordSet variable inside a Script Task

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

ssis etl script-task

SSIS is executing successfully, but it doesn't seem to be running the script task portion

I have an SSIS package that runs an SQL query and exports it to a csv file via a Data …

c# sql-server csv ssis script-task

Cannot get SSIS Script Task to work

I feel like I am missing some configuration or something, because I have followed tons of tutorials online, but cannot …

c# sql-server ssis etl script-task

How can I fix "Error: Exception has been thrown by the target of an invocation." Error in SSIS Script task sending to multiple emails

I'm setting up email alert using SSIS script task. The code works when CC field is only one email but …

sql-server vb.net ssis etl script-task

Powershell returns negative exit code while script results are correct

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 …

sql-server powershell ssis scripting script-task