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
2
votes
1 answer

How to access to existing ADO.NET Connection Manager within data flow script component

I want to execute SQL statement for each row in my Data Flow, so I use script component (not script task) in data flow. I tried code like below, but it doesn't compile. using (SqlConnection connection =…
ensiferum
  • 55
  • 6
2
votes
1 answer

Using regular expression parsing address in SSIS

We know that there is no out of feature for Regular expression in SSIS. We came to know that we need to write .Net script in custom Script transformation. However, we would like to write Java method for this, could any help us whether SSIS can…
Prasad Kada
  • 63
  • 7
2
votes
1 answer

How to add incremental row number in a data flow task in SSIS

I current want to add a new column that allow me to add row number within a data flow task in SSIS (row number increments with each new row). So far I have been using the following code from this guide: I currently am using Visual Studio 2015. HOW…
Yola Z
  • 39
  • 1
  • 3
2
votes
1 answer

Load data from Table with column NVARCHAR(MAX) - Cannot convert to string as value is getting truncated

I have a DFT with OLEDB Source - sql table with column named description data type NVarchar(Max) select max(len(description)) from tbl_Test -- returns 10,000 script transformation editor to perform transformation Output0Buffer.AddRow(); …
sushu
  • 49
  • 2
2
votes
0 answers

Script Component Transformation row value to variable

I have a script transformation component that takes input from an OLEDB source and, for each row, executes a stored procedure with parameters based on the row value. I have used this functionality in past solutions without issue however, it's now…
jbeckom
  • 105
  • 1
  • 2
  • 10
2
votes
2 answers

Extract Multiple Flat File Lines as One Using C# in SSIS Script Component

Within the Script of the Script Component in SSIS, I am trying to create one record from a flat file as shown here: Starting…
Adam
  • 45
  • 4
2
votes
1 answer

PostExecute() Output Buffer Foreach Rows

I have the following code within a Script Component in SSIS. I am trying to de-serialize the JSON Output and output the response to Database. The de-serialize part is returning the response. However I am getting an "Object reference not set to an…
Lucas Perrett
  • 423
  • 1
  • 6
  • 16
2
votes
2 answers

SSIS Script Component to remove '\0' charachers in CHAR(n) fields

I'm currently working on a database that have '\0' characters in fields. For instance the field Category CHAR(4) sometimes has value '\0\0\0\0' (4 zero characters) and sometimes ' ' (4 blank characters) I want to use a script component to…
sergiom
  • 4,791
  • 3
  • 24
  • 32
2
votes
2 answers

Problems inserting data into Oracle table with sequence column via SSIS

I am doing data insert into a table in Oracle which is having a sequence set to it in one of the columns say Id column. I would like to know how to do data loads into such tables. I followed the below link - It's possible to use OleDbConnections…
VKarthik
  • 1,379
  • 2
  • 15
  • 30
2
votes
1 answer

Getting column name from PipelineBuffer in Script Component in SSIS 2012

I'm trying to get the column name and index from the PipelineBuffer in my script component transformation is SSIS and add them to a Hashtable. I know this is possible if I change my class from:public class ScriptMain : UserComponent to ScriptMain :…
jymbo
  • 1,335
  • 1
  • 15
  • 26
2
votes
1 answer

Reading CSV file in SSIS Script Component task

I have created a transformation to copy data from CSV file to SQL Server table. Since my CSV file is dynamic and can have any number of columns at given time, I included a ScriptComponent Task to maintain the mapping b/w 'FlatFileSource' and…
Abhi
  • 85
  • 1
  • 3
  • 15
2
votes
1 answer

Consuming Web Service in SSIS gives 'Mismatch between the processor architecture'

I tried the tutorial below to consume a web service in a Script Component in SSIS. --Link to tutorial-- After pre-compiling I get following warning: Warning 1 There was a mismatch between the processor architecture of the project being built…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
2
votes
2 answers

Does variable value set by Row Count Transformation take effect during execution of DFT in SSIS? or Conditional Split can read a variable correctly?

I have a SSIS package where1 record (hard coded) flow through. I have variable in DFT scope. I assign value to variable using Row Count Transaformation. The value should be 1 i verify it by using script component. public override void…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
2
votes
2 answers

Thread safe random number/string generator for an OAuth nonce in C#

I've been using an OAuthBase class found HERE in my SSIS 2008 C# Script Components (.NET 3.5). It's been working fine, but recently I've ran into the problem where if I execute multiple script components in the same Data Flow Task, using the…
jared
  • 1,344
  • 4
  • 20
  • 38
2
votes
0 answers

Script Component in SSIS shows up as an empty 'VstaProjects' solution

I have SQL Server 2012 Client Tools installed on my Windows 8 machine. I am currently writing an SSIS project which has a lot of Script Tasks. When I double click on a Script Task and then click on the Edit Script... button, I observe the…
bittusarkar
  • 6,247
  • 3
  • 30
  • 50
1 2
3
…
11 12