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
0 answers

SSIS Get Table Name

What I want to accomplish is to get the table name where the Error Description Occurs. What Im thinking is to get the component name of the OLEDB Destination(occupancy/attachedStructures), but I dont know how to do it, or are there any other ways to…
Villapando Cedric
  • 289
  • 1
  • 4
  • 14
0
votes
2 answers

SSIS Script Component Call Stored Procedure returns -1

I tried implementing a call to Stored proc and the proc returns ID which will used later. Everytime I execute I get the out parameter as -1. Below is my sample code: OleDbCommand sqlStrProc = new OleDbCommand(); sqlStrProc.Connection…
user2161578
  • 29
  • 1
  • 2
  • 4
0
votes
3 answers

Reading System Variable from Script Component

What is the best way to read system variables from Script Component. Tried as below: Works fine when is User variable base.PreExecute(); IDTSVariables100 variables = null; VariableDispenser.LockForRead("System::ContainerStartTime"); …
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
3 answers

Reading object variable values in SSIS script component source

Is it possible to read object variable values in SSIS script component source? I have a variable, of type Object, which contains records from table populated by using a SQL Script Task. I have used this Script Task and it's working perfectly by…
Ishan Trikha
  • 251
  • 5
  • 6
  • 13
0
votes
2 answers

How to call a web service with multiple input (in a Script Component) in SSIS?

I need to use a Web Service that allows me to perform a special calculation. To perform this I used a Web Service Task, but the problem is that I only know how to call the Web Service once (1 input value), and I need to perform the calculation for…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
0
votes
1 answer

SSIS Script Component for multiple column data

I have a scenario where I need to insert few records into database. I have analyzed and confirmed that only script component can help me. Since I cannot give the exact data, I will explain the flow using sample data. The main flow has employee…
RakeshP
  • 141
  • 5
  • 15
0
votes
1 answer

Assign values to ssis variable

I am trying to assgin a value to a variable in script component using C# but unable to do so. Can anyone please post the code or tell me what wrong below. public override void PostExecute() base.PostExecute(); IDTSVariables100 varCollection…
RakeshP
  • 141
  • 5
  • 15
0
votes
2 answers

SSIS Data Transformation - Rows to Columns

I have a situation in m current ssis project. I have a huge excel with customer data. The 2 columns have identifiers for the customer data. Something like below. Rest of columns have actual data. COLUMN A | COLUMN B -------------------- NAME |…
RakeshP
  • 141
  • 5
  • 15
0
votes
1 answer

How to a variable value persistent in SSIS?

I have to do an incremental extraction using SSIS. My scenario is something like this: I need to find the maximum of the datetime from my table and store it in a variable that I am using in the where condition of my OLE DB Source. I am using the…
Yousuf Sultan
  • 3,055
  • 8
  • 35
  • 63
0
votes
1 answer

SSIS Script component Transaction

I am trying to use script component as transformation for processing a non formatted flat file. I can achieve everything, but i would like to fail the component as well as the parent component holding it. The target is a oleDB destination. When i…
Linu1988
  • 49
  • 3
  • 8
0
votes
2 answers

where did my c# reference go?

I have not seen a question like this so far - I have a script component in an SSIS package. I have added a few references so far to it. It seemed to work as expected. I added System.Data.Linq and System.Data.Linq.Mapping and it seems to work fine…
uh_big_mike_boi
  • 3,350
  • 4
  • 33
  • 64
0
votes
0 answers

SSIS 2012 + Script Component + Custom .dll reference

Working in SSDT (Visual Studio 2010) I got code for custom dll in C# (Visual Studio 2010) with Target Framework .net 4.0. When I refer to above dll in my SSIS Script Component from the location where its been built it throws an error as below…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
1 answer

Detecting partial rows in SSIS

Situation: A tab delimited row from a flat file source is missing columns at the end of the row. The rows are delimited by {CR}{LF} in the Flat File Connection Manager, and the last column is delimited by {CR}{LF} as well. All other columns are…
kahless364
  • 35
  • 1
  • 8
-1
votes
1 answer

How to solve 'Attribute : .......cannot be set to null' error

I am setting 'statecode' field of entity 'quote' of CRM using script component in ssis as: if(!Row.activated_IsNull) { quote.Attributes["statecode"] = Row.activated; } else { …
Ashish
  • 21
  • 4
-1
votes
2 answers

Newtonsoft.json dll issue in ssis

Can anybody help to resolve this. I have added third party reference (Json newtonsoft) dll in my script component, but when i run the package through sql server agent, I am getting an error Could not load file or assembly 'Newtonsoft.Json,…
Jai A
  • 1
1 2 3
…
11
12