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

SSIS Script Task Error: exception has been thrown by the target of an invocation

I am trying to pass user variables into an SSIS script task to use them in the similarly structured following if clause:- VariableY= Directory.GetFiles(Dts.Variables("User::VarX").Value.ToString, "*.*", SearchOption.TopDirectoryOnly) For Each VarZ…
Momin Goni
  • 19
  • 4
0
votes
1 answer

SSIS Script Component JSON to SQL Server table

I have built a package that updates a JSON file every time I run it; the next stage is to load a single row of data to a table. I am using a script task to load it. Following is my json…
Dhananjay Rele
  • 13
  • 1
  • 2
  • 7
0
votes
0 answers

Iterate through unconnected severs without providing package error SSIS

Created a package that will loop through all the servers in our environment. Package consist of a Foreach loop and within it is a Script Task connected to a Data Flow task and an Execute SQL Task. The purpose of the Script Task is to verify server…
0
votes
1 answer

Develop a dll on Visual Studio and embed it on a dtsx

SSDT has the Script Task that allows developing custom code in C# that's able to process data inside SSIS streams. But this solution is very ugly, because every time we need to edit that code a Visual Studio instance is opened, and it must be closed…
Hikari
  • 3,797
  • 12
  • 47
  • 77
0
votes
1 answer

Find the last folder with concatenated date in ssis

I have a task that need to be done that contains the following: I want to add as a source in the Data Flow a text file which is in a folder with concatenated date as name. For example: somepath\YYYTMMDD I want dynamically the ETL process to find…
0
votes
1 answer

SSIS "The binary code for the script is not found" on script task

I'm seeing that a lot of people are having this issue and so am I. I'm using Visual studio 2015 SSDT 2014 and SQL server 2014. I created a package that has a script task in it, inside the script task I'm using a web reference to a SOAP API. when i…
Elad L.
  • 629
  • 1
  • 10
  • 25
0
votes
1 answer

File downloads from a TLS1.2 site using SSIS

Our current process was working fine and was able to download files until the site decided to switch to TLS 1.2 protocol. Now, our file downloads no longer work. Our existing solution is based on this vb.net solution and this does not seem to handle…
rvphx
  • 2,324
  • 6
  • 40
  • 69
0
votes
1 answer

downloading multiple files to multiple folder using ssis from sftp

I am trying to download multiple files that are located in multiple folders from an FTP site into multiple folders on a specific drive using FTP task and script task in SSIS. I am not downloading the files into one specific folder. I have looked…
Hmen
  • 41
  • 6
0
votes
1 answer

'Assembly is a higher version than referenced assembly' error in SSIS script tasks

In my SSIS packages, I've a script task which references the below assemblies... Microsoft.SqlServer.DTSRuntimeWrap, Microsoft.SqlServer.ManagedDTS, Microsoft.SqlServer.ScriptTask How can i get the same package to work on multiple SQL Server…
Yogesh Irmal
  • 111
  • 1
  • 1
  • 7
0
votes
1 answer

How to access Sequence Container from code of child Script Task in SSIS packages

I have a SSIS package with 4 Sequence Containers. Each one of them has a Script Task. I want to capture the Name of the container from inside the Script Task code. How can I do that? I haven't found a way to access parent objects. I've currently…
Cesar Vinas
  • 343
  • 1
  • 10
  • 20
0
votes
1 answer

Odbc Connection - [ODBC Driver Manager] Data source name not found and no default driver specified

Public Sub Main() Dim connSource As New System.Data.Odbc.OdbcConnection Dim cmdSource As New System.Data.Odbc.OdbcCommand Dim cmdupdate As New System.Data.Odbc.OdbcCommand Dim connsql As System.Data.Odbc.OdbcConnection Dim…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
1 answer

Time parsing Issue using DateTime.ParseExact()

I have a Time Value stored as string with the format HH:mm I used the following code to parse it as date with Today Date DateTime.ParseExact("09:00","HH:mm",New System.Globalization.CultureInfi("En-GB")) The Result Is 2017-03-15 09:00:00 When…
Hadi
  • 36,233
  • 13
  • 65
  • 124
0
votes
1 answer

SSIS Script Task not Executing in SQL job sstep

I have struggled and struggled with this issue. I've read a many similar questions concerning this topic, but I'm new at this and I'm reading "Greek to me". Perhaps someone will be willing to help me on an elementary level with this. I created an…
0
votes
2 answers

SSIS Script task enlist in the current transaction

I have a package in SSIS with multiple task. I am loading file,if the Filesystem task at the end fail i want to be able to rollback the transaction.My package look like that. I like to be able to rollback all the operations the SSIS script have been…
0
votes
1 answer

SSIS script task - Read from XML file, match text with system variable and output value to user variable

I am new with SSIS and struggling with Script task. Trying to figure out how to build script for following scenario. Here is scenario I have XML file has following data
M. Mehta
  • 63
  • 3
  • 10