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 Script task fail, but works again when simply opening the script (no modification) and save it again. How come?

I'm developing SSIS packages on Visual Studio Community 2015 (version 14.0.25431.01 Update 3) with SSDT (version 14.0.61707.300) where I often use SSIS Script Tasks in C#. My Packages are developed locally and then tested on various servers. The…
Arthur
  • 174
  • 1
  • 1
  • 10
0
votes
0 answers

How do I instantiate or mock the Dts object from a SSIS script?

I have very little experience in SSIS packages and BI. I am writing a C# script that will reside in a SSIS package but I want to test it out in my own Visual Studio console application before I deliver it to the BI people who will put it in…
Dudute
  • 357
  • 1
  • 3
  • 11
0
votes
0 answers

SSIS Package Does Not Pass Validation and Does Not Fail or Error Out

All of my SSIS packages that contain a Script Task get stuck in validation and never run or error out. They just hang there and never progress. I'm running VSC2019 Version 16.1.19 on Microsoft.Net Framework 4.8.03761. I'm using the script task to…
0
votes
1 answer

"Script Task" missing in SSIS Visual Studio 2019

My Visual Studio SSIS is missing the "Script Task" tool. There is only "Script Component" tool. I tried to search google for this problem but there wasn't anyone who had encountered the same problem as me. I tried to go to the Extension Download…
0
votes
1 answer

SSIS which having script task throwing "not enough memory resources" error

In one of my SSIS package giving error during the execution time. Package contains two script task which will run in parallel. From script task what I'm doing is that, getting some svg files from a shared location and read it and then convert it to…
Sreepathi
  • 93
  • 13
0
votes
1 answer

SSIS Script task Call stored procedure with OleDB

In SSIS Script task how to execute a stored procedure using oledb connection.
Sreepathi
  • 93
  • 13
0
votes
2 answers

How to create a database, table and Insert data into it and use it as a source in another data flow in SSIS?

I have a need to create a SQL database and a table and Insert data into the table from another SQL database . And also to use this newly created database as a oledb source in another dataflow in the same SSIS package. The table and database name are…
0
votes
0 answers

SSIS Script Task using client.GetAsync(url) not waiting for response

I have an API call using client.GetAsync(url) within a SSIS script task but for some reason its not waiting for response from API and jumping back to the entry point for the script task which is public void Main(). Done some reading and found out…
QuickSilver
  • 730
  • 5
  • 28
0
votes
1 answer

SSIS: Need to Process an excel file in SSIS upto certain range until it finds a blank row

I have an excel file .xlsx which i will get from client and after certain rows data it will have a blank row and then a generic comment everytime and the starting work of that phrase will be same all the time and not the whole phrase. I want to…
TheSacredKiller
  • 121
  • 3
  • 8
0
votes
0 answers

Upload flat file to sharepoint via SSIS Script task

I need to modify numerous packages to deliver a flat file to a SharePoint. I've found this routine online to do it via C# in a script task but I am getting a "remote server returned an error "(403) forbidden" error. Code is below. I am using visual…
user3772443
  • 153
  • 1
  • 2
  • 9
0
votes
1 answer

JSON post to the elastic API using C#

I have an elastic post API. To fetch the data from the post API I am using the below JSON code in the body section in postman. { "query": { "bool": { "should": [ { "match": { "platform": { …
Learner
  • 25
  • 5
0
votes
1 answer

Error at serializer Deserialize in C# code

I am trying to load the data from the API which consists of JSON data in C#. But I am getting an error when I am trying to serializer.Deserialize[]> the data. Below is the sample API data for one record "_index":…
Learner
  • 25
  • 5
0
votes
1 answer

Having issue running SSIS script task in Visual Studio with 2019 as target version

We are upgrading from Sqlserver 2012 to 2019 in that process we need to migrate our SSIS packages also from 2012 to 2019. We have lot of script task which uses connection string and other configurations from DtsDebugHost.exe.config It was loaded…
0
votes
1 answer

SSIS Report: How to rename an excel file in a specific location

We get an excel file in a specific location where the name of the file may vary every time. So every time we rename the excel file manually to "Report.xlsx" and then we have some operation to be done using a script task. The file_Path + file_Name is…
SM079
  • 412
  • 2
  • 7
  • 20
0
votes
1 answer

C# script to load data into SQL Server database doesn't work as expected

I am trying to query the APIs and insert the responses from it in to the SQL Server table using the script task. The script task is behaving in consistent that one time loads the data the other time the execution shows succeeded there is no data in…
user4912134
  • 1,003
  • 5
  • 18
  • 47