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
1
vote
1 answer

Nested JSON Deserialization in C# SSIS

I am using a Web API that returns JSON. Within that JSON there is a base64 encoded JSON string that is returned. The initial response returns JSON that uses the following classes. public class Attachment { public string type { get; set; } …
Lucas Perrett
  • 423
  • 1
  • 6
  • 16
1
vote
1 answer

Change date format of data coming from flat file SSIS

I am reading data from a flat file and storing them in a OLE DB destination. In the flat file, dates and in various formats 17/02/2014, 28-Apr-14, 30.06.14 I have used a Derived column transformation to check for empty columns and replace it with…
BRDroid
  • 3,920
  • 8
  • 65
  • 143
1
vote
2 answers

VB.Net SSIS Script to Trim all Input Columns of Leading/Trailing whitespace

I have an SSIS package that is inputting data from a Flat File into a SQL 2008 database table. The 3rd party generates the Flat File (.csv) every day. There are leading whitespaces in every field that I need to remove. I thought a Script Component…
Gemini
  • 109
  • 2
  • 15
1
vote
1 answer

In the SSIS Script Component, what is the difference between ProcessInput() and Input0_ProcessInputRow()

I have always assumed that the Input0_ProcessInputRow(Input0Buffer Row) method runs once for every row being passed through the script component: public override void Input0_ProcessInputRow(Input0Buffer Row) { //Code in here runs once for each…
Bert Wagner
  • 851
  • 1
  • 11
  • 23
1
vote
1 answer

Converting a PeriodStart and PeriodEnd to year + week number

I'm trying to convert a start + end date into multiple rows filled with weeknumbers and the year connected to it. My idea is to convert this start + end date in SSIS with a Script component, and create rows for each week by setting SynchronousInput…
Alim
  • 227
  • 1
  • 4
  • 18
1
vote
1 answer

Deploy SSIS Script to Toolbox

I am trying to deploy a Script component to SSIS toolbox in the Data Flow for reuse. I'm using visual studio 2010, and SQL server 2014. I have created the script, Signed the assembly, used Gacutil.exe /i on the DLL file to add it. It now recedes in…
Sweetspot
  • 91
  • 1
  • 9
1
vote
1 answer

Converting day, weeknr and year to date

I've been given an excel document in which worktime information is noted, this document contains certain columns which are being read by using SSIS in visual studio, after that the information is writen to a Database. The week and year column…
Alim
  • 227
  • 1
  • 4
  • 18
1
vote
0 answers

Is there a version-specific compilation symbol when SSIS compiles script components?

I have packages that use script components as a data source. Some of them override the PrimeOutput method from the Microsoft.SqlServer.Dts.Pipeline.ScriptComponent class. In 2008, this method has 3 parameters, but starting in 2012, it now has four…
Brian Ball
  • 12,268
  • 3
  • 40
  • 51
1
vote
1 answer

Adding a .dll from GAC to SSIS script component doesn't work

I am trying to reference a custom class library (C#) in a script component of my SSIS package. The library has a strong name. I deployed the .dll to GAC via gacutil. I am administrator and I really tried everything else I could find on the www. If I…
チーズパン
  • 2,752
  • 8
  • 42
  • 63
1
vote
6 answers

Script component Fail: System.IndexOutOfRangeException: Index was outside the bounds of the array

In SSIS package “script component” is failing due to the following exception. This exception is occurring sometimes only. This script component contain Try/Catch, still it’s failing. What could be the reasons for this exception? Error…
Dav1
  • 11
  • 1
  • 2
1
vote
1 answer

Will ssis script component output be sorted?

I am adding rows in sequence in a script component. The sequence is such that I am parsing values from an input string then adding them to the output. This way all values from a particular input string are added before those from the next input…
Pete_ch
  • 1,301
  • 2
  • 28
  • 39
1
vote
1 answer

How to determine the last row of rowset for further processing during data flow?

I have a problem regarding SSIS 2014 data flow. I need to determine the last row of the rowset during the data flow. I need it for further processing inside the same data flow. Using the script component, I tried the functions NextRow() and…
17nxo
  • 87
  • 1
  • 3
  • 10
1
vote
1 answer

SSIS Script Component - Process 1 Row of Json to Table

I'm new to SSIS. I'm trying get a field that contains a Json string from a table as the input, and convert the Json into a table as the output. I have setup an Asynchronous Script Component in SSIS, selected the Json field as input column, and also…
user3268139
  • 352
  • 2
  • 3
  • 16
1
vote
2 answers

Need faster way to pull oData feed in SSIS

Is there a faster way to grab oData for ssis? public override void CreateNewOutputRows() { SomeEntities entities = new SomeEntities(new Uri("https://aurltomystuff.com/mywebservice.svc/")); string username =…
Chris Hayes
  • 3,876
  • 7
  • 42
  • 72
0
votes
1 answer

Using SMO Library in SSIS 2008

Good afternoon, Im having some trouble writing a simple script using SMO objects in C# to validate if an object exists and then create it. This code is within a Script Task Component in SSIS. The code executes successfully, however the new database…
user1253174
  • 1
  • 1
1 2 3
…
11 12