Questions tagged [script-task]

The Script task provides code to perform functions that are not available in the built-in tasks and transformations that SQL Server Integration Services provides. The Script task can also combine functions in one script instead of using multiple tasks and transformations. You use the Script task for work that must be done once in a package (or once per enumerated object), instead than once per data row.

Do not use this tag for the SSIS Script Component, instead use .

Check the following article for more information: SSIS Script task vs. Script Component


Based on the official SSIS documentation, SSIS tasks are categorized as the following: Data Flow Task, data preparation tasks, workflow tasks, SQL Server tasks, Analysis Services tasks, maintenance tasks, custom tasks, and scripting tasks.

The SSIS Script Task extends the package functionality by using scripts. It performs functions that are not provided by the standard Integration services tasks.

363 questions
0
votes
1 answer

SSIS reading operating system environment variables

On a Windows system, when I open a DOS command window, I can retrieve the value of operating system environment variable by running this: C:\Users\me>set MyApplicationEnvironment MyApplicationEnvironment=Staging I would like to do the same thing in…
TPV
  • 61
  • 1
  • 5
0
votes
0 answers

Script Task working in Visual Studio but not when package is deployed

I have a script task (excerpt code below) which is supposed to open an Excel Workbook: If CountOfT > 0 Or RowsUnallocated > 0 Then Workbook = Workbooks.Open(BrkStTmpFolder + "NewTemplate.xlsx") 'MsgBox("Break Point") …
0
votes
0 answers

SSIS Script Task on production raised exception Using Microsoft.SharePoint.client

I'm trying to delete Microsoft Sharepoint lists items using the SSIS C# script task. It's working fine on my local computer. I installed Microsoft.SharePoint. dll on my computer to do this task. Below is what I have done on an SSIS Package script…
Bumblebee
  • 179
  • 1
  • 16
0
votes
1 answer

How can I detect if there is any file in a folder using SSIS?

I receive every day a file with a specific pattern and extension, which I want to run under certain process. I want to check if there is any file in my folder, because otherwise I will do another task. So far I found that you can use a Script Task…
0
votes
0 answers

SSIS ScriptTask OnTaskFailed event handler not capturing the ScriptResults.Failure result

This is something that is really down to fairly advance knowledge of the .NET framework but I haven't been able to find the information I needed. I have an SSIS package that executes a ScriptTask. Within that ScriptTask the below simple code: public…
JosePaya
  • 323
  • 3
  • 7
0
votes
0 answers

Using Script Task Editor in Visual Studio 2017 after update to Visual Studio 2017 SSDT no longer working

I am working on an SSIS package in Visual Studio 2017 SSDT. I had an update come through for Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT) Version 15.9.18 and it updated successfully. I went to open one of my SSIS packages and when…
Melinda
  • 1,501
  • 5
  • 25
  • 58
0
votes
0 answers

Issue with Async await while calling API in loop in SSIS script task

I am calling a c# web API using SSIS script task. The requirement is to pick request data from a table, convert each row to a request, call API for each request and store response in a table. I am looping around all rows of the table and calling API…
gourav
  • 1
  • 1
0
votes
0 answers

SSIS: Script to get a report from a Website

I've trying to get a report from a Website. I have the Username and Password. When I navigate through the website set my report and download it manually. The other way that I found with the browser open copy a link like this and download the…
AGDiaz
  • 53
  • 1
  • 6
0
votes
1 answer

SSIS Script suddenly won't build

I have a script that creates a directory oath based on two variables. I was trying to troubleshoot it when the script suddenly stopped building. First, there is a read only variable that provides the directory/folder (User::sPriceListSourceFolder).…
Vaslo
  • 480
  • 1
  • 5
  • 22
0
votes
1 answer

Parsing variable length record to table columns where specific column is dynamic in SSIS 2016

I have a table that has 45 columns for tax values | Tax1 | Tax2 | .......... | Tax 44 | Tax45 | I read in a variable length positional record that can contain zero to 90 values. The record is structured so that the first 3 characters are the tax…
Kulstad
  • 79
  • 8
0
votes
2 answers

Getting error in Script Task Editor in SSIS

I am trying to upgrade SSIS package from 2013 to 2017. But, I am getting error for the below lines of code. Can anyone please resolve this? I am new so I haven't tried anything yet. using System; namespace ST_3e6cc55d375c472785d01c446ea4bf8b { …
Tony
  • 55
  • 6
0
votes
0 answers

SSIS package fails to run when called from a SQL Server Agent job step

I have an SSRS report. I am downloading that as an Excel file through SSIS package. I have created a script task for that. This is working fine. But the problem is when I am trying to run the SSIS package through SQL Server Agent job, it fails. I…
0
votes
1 answer

How to Encrypt the password to Excel using SSIS package? Is it possible?

How to Encrypt the password to Excel using SSIS package? I thought, we can use script task to achieve this. I tried the below code by using the Spire.xls nugget package but the respective nugget dll reference are not adding to the solution. Script…
0
votes
2 answers

FTP task fails due to variable path

I'm getting the below error when trying to process FTP task,i need using rename FTP task, it continuously fails when in this step, I'm unsure if the path is correctly defined. In the destination i'm basically calling destination variable + filename…
user8097616
0
votes
1 answer

How to configure the alfresco to run a script-task

I am trying to run a script task in alfresco process services, while compiling the script there were some error throw out in the console as like: the console couldn't run 'javascript' var x=5; var y=5; var xy=x*y; document.write("The result…