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

How to save content of list into OBJECT type

I have a list/tuple which I have populated with some values. I want to save these values into a variable of OBJECT type in script component. How can I achieve this. Till now I did tried this with no success. public class ScriptMain :…
Ashish
  • 359
  • 1
  • 6
  • 13
0
votes
3 answers

SSIS Data Flow Task Error: Object reference not set to an instance of an object

I am trying to create a package containing several Data Flow tasks in them. The tasks are fairly similar in nature, but contain fairly important differences. I have tried to copy the task, then change the things which need changing. When I run the…
Mike de H
  • 599
  • 2
  • 6
  • 13
0
votes
0 answers

SSIS - Create Summary Output File

I would like to use SSIS in orded to perform tranformations on multiple files (CSVs, Excels) which are comming from various datasources and the output should be always CSV files in certain structure. One of the requirement after performing…
Martin Lučan
  • 51
  • 1
  • 4
0
votes
1 answer

SSIS: How can I convert an NTEXT input to a string to perform a Split function in a script component?

I receive a Unicode text flat-file in which one column is a single fixed-length value, and the other contains a list values delimited by a vertical pipe '|'. The length of the second column and the number of delimited values it contains will vary…
osboy1
  • 124
  • 9
0
votes
1 answer

How to update Name field in Pricing Approval Products(Custom Entity) in Dynamics CRM using ssis script component

I need to update Name field in Pricing Approval Products using ssis. This is my Code in script component. public override void Input0_ProcessInputRow(Input0Buffer Row) { Guid AppProductLookup = new Guid(); AppProductLookup =…
xChaax
  • 193
  • 5
  • 27
0
votes
3 answers

SSIS setting variables in Script Component of Data Flow

I have an input flat file that has 2 types of input records for each output record. The first record (identified by C in first column) has an ID and Demographic information. The second record (identified by L in first column) has some financial…
Dick Rosenberg
  • 113
  • 2
  • 10
0
votes
1 answer

SSIS Web Service Script Component (The given key was not present in the dictionary)

I'm sorry if this question has been answered already, but I've done some research and have yet to find something that makes sense. I'm creating an SSIS script component that connects to a web service and is to dump data into a SQL table. Though the…
darksideguy
  • 91
  • 4
0
votes
1 answer

SSIS: Trim some columns w/o doint a Trim in a script component...::::

I have a table with 48 fields, i am filtering some data and need to use a script component( i need this for 10 of the fields in which i am actually changing the data) on the other 38 fields I only want to do a trim. I know i can do this in a…
asd
  • 15
  • 1
  • 4
0
votes
0 answers

SSIS - Dynamic Script Component

I want to build a dynamic script component as source and destionation for multible tables. I just started by sample at Microsoft Page. It is working for specific table but now need to convert it to dynamic for all tables but need your helps. First I…
Can Aslan
  • 53
  • 2
  • 11
0
votes
0 answers

How to insert rows one by one with Script Component's Outputbuffer

I have a Script Component in SSIS 2012 which takes the data from WebService(json), deserialize it and inserts into table. This works correct but sometimes the Webservice is down and I get the 500 error. So I wanted to log these errors to the…
cybernetic87
  • 285
  • 1
  • 13
0
votes
1 answer

Decode Base64 HTTPWEBRESPONSE in C# - Returns Japanese

I am using an SSIS Script Component to execute C# code for a WEB API that is returning me a value that is a Base64 Encoded byte un a return array. The actual return value is an encoded JSON string which I subsequently need to deserialize and…
Lucas Perrett
  • 423
  • 1
  • 6
  • 16
0
votes
0 answers

SSIS Package System.OutOfMemoryException

When I was runnig SSIS package, some Data Flow Tasks throw exception System.OutOfMemoryException. I use Script Components in Data Flow Tasks.This script components execute queries, gets data from source database, this datas about 1,5GB , I keep…
Taner Aydoğan
  • 11
  • 5
0
votes
1 answer

2008 R2 - SSIS Script Component Output - Variable Column Length

Using SQL Server 2008 R2, BIDS, to create a SSIS package. I'm trying to use a variable to define the length for one of my script component outputs in my data flow. Obviously this doesn't work. I'm wondering if there is a workaround so I don't have…
Ben Y
  • 291
  • 6
  • 14
0
votes
2 answers

How to get custom dll's working in a ssis script component?

I try to use my own .dll in a script compoment within ssis. The normal procedure gives me an error: "could not load file or assembly 'xxx' or one of its dependencies. The system cannot find the file specified." What I tried yet is I went to project…
ruedi
  • 5,365
  • 15
  • 52
  • 88
0
votes
2 answers

SSIS Script Transformation Error

SSIS Script transformation is giving an error: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully" I have opened the editor and rebuild ,but shows…
user1254579
  • 3,901
  • 21
  • 65
  • 104
1 2 3
…
11 12