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
0 answers

Salesforce Bulk API 2.0 in SSIS Script Task

Have anyone tried using Salesforce BULK API 2.0 in SSIS Script task. I was able to create the job and generate the CSV from the SQL query but when I am trying to use the HTTP PUT method for adding the data to the job it is not working. Following the…
0
votes
1 answer

SSIS package to load data to Salesforce using BULK API

I am using SSIS and trying to load object data to the Salesforce with REST API using Script Task, but the load request timeout in between without any error. I have to monitor the progress of the load and manually stop the job in case the data is not…
0
votes
1 answer

How can I send out a script task email in SSIS that includes all files found in folder

I am creating a package and the 1st step is it sending out an email(using script task, script language microsoft visual basic 2019) that tells the recipients what files have been received for processing. I am currently doing this with a ScriptTask…
0
votes
0 answers

download Amazon S3 file using SSIS script task

I'm trying to connect to Amazon S3 bucket using SSIS script task and because i'm not an expert at all in C# coding in SSIS, could anyone please help me achieve this and below i have a sample example from the internet of a C# code of how to download…
vani malge
  • 85
  • 1
  • 6
0
votes
1 answer

Runtime error Exception has been thrown from Script task

I'm new in the area and I need to run a script for SSIS project. Here's the script: public void Main() { var server = Dts.Variables["ExcelFileName"].Value as string; var xlApp = new…
0
votes
0 answers

Clone xlsx sheet within same workbook in SSIS

I am working on SSIS package where i have to clone xlsx sheet within same workbook. Is there any way to do so without using interop dll. Can we achieve this by using OLEDB connections?
Yash
  • 191
  • 2
  • 3
  • 14
0
votes
1 answer

SSIS script task to verify table full of URL's

I am going to apologize ahead time in saying that I am pretty new to SSIS but I've been assigned a project that involves connecting to a table and verifying URL's that part of a products 'attributes'. The verification would basically be looking for…
tom pratt
  • 35
  • 6
0
votes
1 answer

SSIS - Open XML file, find string between 2 strings and left the found string

I have an XML file that has several records. I have an implemented process that takes that file and inserts it into a table. The problem is that there is an xml record in the Description column that is almost 20000 characters long. What I wanted to…
0
votes
1 answer

How to write C# script to handle double quotes in csv fields in SSIS

My requirement is that I am getting a CSV source file like this: ID,[%age],[name] 75,8,"Ander,Pat" I want to create a dynamic SQL table from this csv like below: ID,[%age],[name] 75,8,Ander,Pat (this should come in a single column) The problem is…
sword_s
  • 3
  • 4
0
votes
1 answer

SSIS Script Task getting "Exception has been thrown by the target of an invocation." when running with 3rd party dll

I have a process that had been deployed to a production SQL Server SSIS catalog for a couple years, and had been working fine daily. Recently an update was made and deployed. It turns out that source control didn't have the latest working revision…
Jeffrey Van Laethem
  • 2,601
  • 1
  • 20
  • 30
0
votes
1 answer

SQL Server Agent Error - Exception has been thrown by the target of an invocation

I am doing a script task in SSIS and scheduling the task using SSIS Agent. I am able to execute the Script task successfully but I am getting an error when I am trying to run it through SQL Server Agent - Error Error: 2020-11-13 12:31:29.64 Code:…
0
votes
1 answer

How modify datatable in C#

I am new beginner in SSIS, I am taking data from excel source. Excel source has columns like A,B,C,D,E,F. I created datatable1 and datatable1 contains columns A,C,D. Now I want to create datatable2 from remaining columns from sheet which are not in…
jackhelsi
  • 149
  • 1
  • 2
  • 10
0
votes
0 answers

Fetching excel sheets in script task SSIS using C#

I am a novice in C#. but I am working on a SSIS C# script which has to deal with list of files and rename sheets of each file. I have a list of excel files it can be .xls or .xlsx format. I am writing a c# script in SSIS script task to loop through…
VRaju
  • 21
  • 1
  • 8
0
votes
1 answer

Return XHR value in C# (Script Task SSIS)

I'm trying to get the value from a XHR e.g. http://www.mypage.com/step/make/validateuser.php?user=test456&password=test123. I was testing with HttpWebResponse and other ways that I find here, but without success. The code below was the last tested,…
ito
  • 145
  • 6
0
votes
0 answers

System.IO.FileAttributes is not the same as the enum type System.Reflection.PropertyAttributes in C# /SSIS

I'm trying to identify whether the content inside a fileinfo object is a directory and if not I need to add them in a stack. I'm trying with the below code but getting the subjected error in the "IF condition" not sure how to proceed from here. Any…
Gowtham Ramamoorthy
  • 896
  • 4
  • 15
  • 36