Stack Overflow
Stack Overflow

Questions tagged [script-component]

The Script component hosts a .NET script and enables the SSIS package to include and run custom script code. The Script component provides an easy and quick way to include custom functions in a data flow.

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

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

General Information

SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties.

Articles

168 questions
0
votes
1 answer

index was out of bounds error in vb.net script

I am having the index was out of bounds error for the following script. I have 1 input column and 11 output columns added to the SSIS Script component. The data types for all of them are string. Not sure where I am going wrong. Thanks in Advance.…
rvphx
  • 2,324
  • 6
  • 40
  • 69
0
votes
0 answers

Define package variables in Script component and use them in another script component in SSIS

I use SSIS to work on a project where I use xml files. So I'm in an SSIS data flow. In a first script component, I perform actions on the xml (I take the first line and the last one and perform actions). Depending on what I receive, I'd like to…
Dexter
  • 21
  • 3
0
votes
1 answer

Assign a Runtime Value to an SSIS Component

I needed to assign a value to this querystring at runtime, I tried using variable but it doesn't work. I also thought about using a task script but I don't know if I can assign values to a component through the script. Does anyone have an idea if…
Marcos Paulo Amaral
  • 15
  • 2
0
votes
0 answers

SSIS data load - How do I load data from csv file which has first few rows that have to be transposed to columns and load remaining data as is

I need to load data from a csv file to SQL via SSIS. The data in the csv file is as follows: I need the data to be loaded into SQL in the below format. how can I achieve this through SSIS?
Tara
  • 73
  • 2
  • 9
0
votes
1 answer

deserialize mongodb datetime field "$time" of JSON document field in C#/SSIS Script component

I am trying to deserialize a mongodb's datetime "$time" field from a JSON file in Script Component SSIS/C# WITHOUT using newtonsoft. This is how far I have reached. Thanks for any help. Example of my JSON…
Lazytitan
  • 47
  • 1
  • 11
0
votes
1 answer

Deserialize complex nested json in Script Component SSIS WITHOUT using newtonsoft

I am trying to deserialize complex nested JSON in Script Component SSIS WITHOUT using newtonsoft. This is how far I have reached. Thanks for any help. Deserialize complete JSON Example of my JSON…
Lazytitan
  • 47
  • 1
  • 11
0
votes
1 answer

How do I import CMS Open Data using API?

I'm trying to deserialize the data from CMS Open Payments API using the code below. However, I'm receiving NULL values even though there is data. When debugging, I'm unable to to find any JSON data sets (again, the website shows data…
Steven
  • 139
  • 1
  • 11
0
votes
0 answers

SSIS Script component merging 2 input rows from buffer

I have an existing SSIS package that reads a flat file and transforms the data based on the 1st 2 characters on each line. Everything works fine, except when the script component tries to process the following 2 rows of…
rvphx
  • 2,324
  • 6
  • 40
  • 69
0
votes
1 answer

SSIS Script component size

I have a problem while using a C# script component in SSIS. The main "Script Transformation Editor" window is cropped at the "Edit Script..." level. I can't see the Ok and Cancel buttons, so I can't save this script. Do you have a solution ? Thanks…
Dexter
  • 21
  • 3
0
votes
0 answers

SSIS Script Component Error while fetching from API

I am a newbie in c#. So for an etl, I am using SSIS component to fetch the data fusing API key and combine the fetched data with data from other sources. so I am using the SSIS 'Script Component' to fetch the API data using the below code. …
Deeins
  • 1
0
votes
0 answers

Script Component not working when change my SSIS project version from 2019 to 2012

I have a SSIS Project which is perfectly fine with my Sql Server 2019. Now I need to deploy same project into Sql server 2012. After I change my target server version to 2012, the Script component in my package which generates the ErrorColumn name…
Kazem
  • 1,450
  • 2
  • 11
  • 13
0
votes
0 answers

SSIS Script Component VS_ISBroken during execution from Integration Service Catalog but working from Visual Studio

I have a SSIS Package which is pulling data from ODBC source and loading it in OLEDB destination. The destination table does not contain an Identity column. I need to get the Max(Id) from the column and increment it by 1 for the next set of records.…
Abhishek Dubey
  • 1
  • 1
0
votes
1 answer

SSIS Script Component convert Object type variable to Int Variable

I need to load data from ODBC source to OLEDB destination. The OLEDB destination table does not contain Identity column but it does have a Primary key column where the values has to be inserted similar to Identity column(increment it by 1). I have…
Abhishek Dubey
  • 1
  • 1
0
votes
2 answers

Get previous row's data and calculate growth in SSIS script component

I have a table like this : Month_ID Month_Sales 1 500.0 2 250.0 3 150.5 I want to add a new column to this table which is "Growth" where : Growth = (Current Month Sales - Prev Month Sales) / Prev Month Sales I want to…
Mahmud Mridul
  • 95
  • 1
  • 9
0
votes
1 answer

SSIS Package Script Component Won't Show

I have a strange bug, I have a loop in my control flow, amongst other things in the loop I have two data flow tasks, each of these has a script component in it. When I use the Edit Script button the new window opens but the Solution Explorer is…
cicconej582
  • 1
1 2 3
…
11 12