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

Loop dynamically through objects

I want to import columns via the script component in SSIS. As output I created Col1 to Col50. Usually I would use File1OutputBuffer.Col1 = columns[0]; but since the column length is not identical I would like to set a loop like Dim count As…
ruedi
  • 5,365
  • 15
  • 52
  • 88
0
votes
1 answer

ssis script component open empty solution

I have a fresh installation of Visual Studio 2015 Pro Update 2 + SSDT (June 2016). When I attempt to edit C# code of my SSSIS script component (clicking on Edit Script...), VSTA does open without any warning/error but does not display anything (like…
Sylvain
  • 21
  • 2
0
votes
0 answers

Using List in SSIS Script Components

I have two Script Components. Fist create list and save it to the Variables.customClasslist (System.Object). When I try read this variable in the second Script Component, SSIS give me an error. List CustomClassList =…
user4274172
0
votes
1 answer

C# SSIS How to iterate through columns and set to null

I need to set any columns that are empty strings to an actual null value in SSIS Normally I can just use a Derived Column and set it to NULL(DSTR, 18, 1252) Since I have loads of fields and want to do it in one go, I have decided to use a script…
Skids
  • 33
  • 5
0
votes
3 answers

PostExecute not firing in SSIS script component

I have a Source Script Component in SQL2012. I believe if you want to set a Read/write variable in the Scriptcomponent it must be set in the Postexecute method . And I have done so like this; public override void PostExecute() { …
ErickTreetops
  • 3,189
  • 4
  • 27
  • 37
0
votes
1 answer

SSIS 2008 Script Component Update record

I am trying to move data from one database to another and need to do some massaging of the data in a script component. The thing is that, though I can declare all the fields in the component, it seems rather counter to the nature of SSIS to do…
10thTiger
  • 95
  • 2
  • 10
0
votes
2 answers

Abort processing of Row in ProcessInputRow method?

Is it possible to abort the processing of a row in the ProcessInputRow method? I'm doing some data validations with the incoming CSV data in this function. I'm setting the row values in a sub. If an error occurs i'll catch it in the ProcessInputRow…
devployment
  • 2,121
  • 1
  • 22
  • 33
0
votes
2 answers

SSIS Lookup with Lookup Component Vs Script Component

I need to load Dimensions from EDW Tables (which does maintain historical records) and is of type Key-Value-Parameter. My scenario is ok if got a record in EDW as below Key1 Key2 Code Value EffectiveDate EndDate …
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
2 answers

Executing Stored Procedure for each InputRow + SSIS Script Component

In my Script Component, am trying to execute Stored Procedure => which return multiple rows => of which need to generate output rows. Code as below: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
1 answer

How to remove words in a flat file from a column string of words using SSIS

I have a simple flat file like this: Forbidden Words Word1 Word6 Word3 Then I'm going to remove these words from a column values in a table like this(words are separated using ';'): Original Column…
Hossein Narimani Rad
  • 31,361
  • 18
  • 86
  • 116
0
votes
2 answers

What does base.preexecute(); or base.postexecute() actually do?

When I create a new script component within SSIS, the preexecute and post execute methods contain the base.PreExecute(); and base.PostExecute(); lines... I want to know what these lines do, and the ramification for modifying/removing them. Thanks!
Tim T
  • 140
  • 2
  • 11
0
votes
0 answers

How to Parse BlobColumn into Words, while removing spaces and carriage returns, in SSIS?

I've created a data flow in SSIS that takes the contents of a text file and uploads it into my SQL Server database table as a BlobColumn. The text file is a document containing sentences, carriage returns and line feeds. I have an Execute SQL…
SidC
  • 3,175
  • 14
  • 70
  • 132
0
votes
0 answers

How to import excel file using dynamic sheet name in SSIS

I am trying to import excel file and load it into sql sever database and i have created dynamic folder path and the file name as dynamic but my only issue is that i am not able to create dynamic sheet names. Users can put a new excel file with…
moe
  • 5,149
  • 38
  • 130
  • 197
0
votes
1 answer

SSIS Script Component Closing Reader

I am having an issue with my SSIS Script Component. It seems that my Reader is getting closed before my CreateNewOutputRows method gets a hold of it. Would anyone be able to help me out? OdbcConnection odbcConn; OdbcCommand odbcCmd; OdbcDataReader…
scapegoat17
  • 5,509
  • 14
  • 55
  • 90
0
votes
1 answer

How to add rows using SSIS 2008 Script Component during transform?

I have a SSIS 2008 script component which is setup as a transform (so it has an input and output), and what I want to do is take 1 row in an input and optionally output multiple rows. In 2005 there was the AddRow and CreateNewOutputRows methods but…
Robert MacLean
  • 38,975
  • 25
  • 98
  • 152
1 2 3
…
11 12