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

Script task in SSIS package is executing but not performing the action

I have the two SSIS packages which basically has two action like below First it truncates the contents of the table and then it executes the script task like basically call an API and inserts the response in to the…
user4912134
  • 1,003
  • 5
  • 18
  • 47
0
votes
1 answer

Find missing files (dates) in folders using C# Script Task

I have some flat files with filename includes date in yyyyMMdd format. Here are some example: Folder Path:…
SafeGuy
  • 369
  • 2
  • 5
0
votes
1 answer

Script task output to check if condition

From the script task I get an output { "resultSetCount": 1, "recordsAffected": 0, "resultSets": [ { "rowCount": 1, "rows": [ { "flag": 1 } ] } ], how to build an expression to check if the flag is…
Equator
  • 77
  • 8
0
votes
1 answer

How to access Azure Key Vault Using SSIS Script Task?

Need to access Azure Key Vault using SSIS Script Task in C#, to assign the Azure SQL Connection String to Connection Manager in SSIS.
0
votes
2 answers

XslCompiledTransorm Transform marking Right Single Quotation as Invalid character in Encoding iso-8859-1/UTF-8

I am trying to generate a text file for each XML file from a third party system using SSIS package script task and XSLT. Sometimes few special characters appear in these XML files. One such character is the right single quotation mark ’. Because of…
ninja_md
  • 165
  • 3
  • 15
0
votes
0 answers

SSIS script task failing to send email SMTPexception:System.IO.IOException: Unable to read data from the transport connection: net_io_connectionclosed

I am using a script task in SSIS to send emails. Code snapshot below: It is failing with the below error: Please note, it was working fine a couple of weeks back. What I have tried so far: Tried changing SMTP details to gmail. It works fine with…
0
votes
1 answer

How to split the files based on size in ssis script task

How to split the files based on size in ssis script task? I tried in many ways but iam not getting the exact script for this.
0
votes
0 answers

I am getting problem to Convert single excel sheet to .CSV format in SSIS

I am able to convert the excel file sheet to CSV by using script task but my all Excel sheet is getting converted to CSV.So I need a single sheet to convert to CSV.
SGS
  • 31
  • 6
0
votes
1 answer

SSIS Task - FTP Conecction

All, SSIS - trying to make an ftp connection to upload files to an ftp server using a script task in visual basic programming language, I have run into a problem. I have not found something similar in my searches so I would appreciate your…
Fido
  • 1
  • 1
0
votes
0 answers

How do you increase the timeout for an SSIS script task

I have a script task that is hitting the default timeout, which appears to be 10 minutes. To increase this do you have to do it within the script or is there a setting somewhere, similar to how you can set it on the connection manager? I don't have…
0
votes
1 answer

The Binary code for the script task is not found. Please open the script in the designer and make sure it builds successfully

I've been trying to solve exercises for Knight's MS SSIS 24 hour trainer. I have a script task in a package that checks the value of a variable and displays a message box. There are no other components other than this. When I try to build the Script…
Arpit Chinmay
  • 313
  • 5
  • 16
0
votes
1 answer

SSIS Convert the data type object variables to Datetime variables

Here, I am using the Dataflow task, in that "Recordset Destination" task is used and Datetime field result is assigned to Variable. I want to use that result [ maximum date] in the control flow for "execute sql" task as datetime parameter. only one…
Raja
  • 3
  • 3
0
votes
0 answers

DTS Script Task: Runtime Error in SSIS Script Task

I have a problem with the SSIS package. When the process hits Execute Script Task I’m receiving the following error. The process is even not reaching the breakpoint which is in the C# script. However, I found out that if I comment major part of a…
0
votes
1 answer

Stored procedure returns multiple temp table results. I want to copy them into one CSV file using C#

I have a stored procedure that has multiple select statements using temp tables. I want to copy the results into one CSV file. Each result has different columns. I would like to copy them in such a way that each result set should leave two lines of…
Bumblebee
  • 179
  • 1
  • 16
0
votes
1 answer

Remove Column from CSV file using SSIS

I have a CSV file that I am using as a source in SSIS. The file contains additional blank columns in the file There is an additional column in S, U, V; is there a way I can remove the column through SSIS Script Task before using it as a source…