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

How to create an Asynchronous Script Component in SSIS?

I might be blind, but I don't see how to CREATE the script component. I'm not asking why do an asynchronous, how to work with it, etc. I just want to know how to add it to my package, or how to transform an already existing component into an…
Tipx
  • 7,367
  • 4
  • 37
  • 59
1
vote
1 answer

SSIS Scripting Component: Get child records for creating Object

Got it working - Posted My solution below but will like to know if there is better way Hello All I am trying to create Domain Event for a newly created (after migration) domain object in my database. for Objects without any internal child objects it…
TheMar
  • 1,934
  • 2
  • 30
  • 51
1
vote
0 answers

JSON Post Request In C#

I am a SQL Developer, JSON and C# are completely new to me. I am trying to get the JSON data from Rest API from elastic DB using POST method. I think my code is incorrect since I am getting all the response from the API even though I am passing…
Learner
  • 25
  • 5
1
vote
0 answers

SSIS-package fails with 0x80131501 despite no problems in Visual Studio

UPDATE! SOLVED. After many hours of trouble shooting we found out that for some reason the API required TLS 1.2 from one server, while normal SSL was fine for another. How it can be like that is beyond me, but this was the problem. Once we…
Gustav
  • 11
  • 3
1
vote
1 answer

SSIS Script component: FileNotFoundException: Could not load file or assembly 'MongoDB.Driver

I'm using a script component to upsert data to MongoDB. As MongoDB driver is not signed, and thus can't be added to GAC, I using the following method to load it at runtime from the known location where all needed reference DLL are saved: private…
Oscar
  • 13,594
  • 8
  • 47
  • 75
1
vote
0 answers

Query expression throws usupported data type in pipelinebuffer

Having a script component that transforms and push an update to CRM 2015. the package throws an error: After a long investigation I found that the line with QueryExpression from the SDK throws the error, I mean When it is commented the execution…
sadzag
  • 73
  • 8
1
vote
1 answer

How do you change the value of the a SSIS variable within the package using Script Component in Data Flow

I am downloading a json file and successfully putting it in a table using data flow and script component object. Within my json file there is a count of numbers row I should import and how many pages it would take to import the data. e.g. "count":…
user11034054
  • 41
  • 8
1
vote
1 answer

SSIS Compilation problems - DirectRowToOutput

Input buffer does not contain a definition for 'DirectRowToOutput0' or likewise for the the other properties below. Row.DirectRowToOutput0(); Row.ErrorMessage = ex.Message; Row.DirectRowToFailedValidation(); I had some packages on SSIS package…
Scotty J
  • 54
  • 1
  • 6
1
vote
1 answer

SSIS Script Component stripping underscores from column names

SSIS Script component strip's under scores from columnnames. Example : ColumnName : Customer_ID in Script components it looks as public override void SourceIn_ProcessInputRow(SourceInBuffer Row) { Row.CustomerID } How can i get Column Name…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
1
vote
1 answer

Date Formats When Reading Excel with SSIS

experts! I've got two similar Excel files (xlsm) as templates. Both have sheets with Date column. Visible format for both files when use Excel is "10-Aug-20". But when I read these files with SSIS process with Script Component Source using…
Alexander Chernov
  • 31
  • 5
1
vote
0 answers

SSIS - "There was an error while building."

does anyone had this issue before? When I try to build a Script Component in SSIS but get the following error: This does not give any context and actually it never starts the building so I don't know what is this.
SuperSql
  • 81
  • 6
1
vote
2 answers

ssis adding year to date of database with script component

i have a database with no year, only day and month (example 20-12). because of this, the database adds the year automatically. The problem with this is, that in some cases the year is ahead of time, for example 20-12-2020, while it's actually…
user7418776
  • 57
  • 7
1
vote
2 answers

SSIS component to remove linefeeds from all (n)varchar fields in dataflow

I use a SSIS component to retrieve data from an API. The API delivers XML, This XML contains data like this: code Linefeeds before and after 'code' That means that what is entered into my (n)varchar columns in SQL looks like…
Henrov
  • 1,610
  • 1
  • 24
  • 52
1
vote
2 answers

ScriptBuffer throws NullReferenceException when called from an Event as part of a loop - SSIS Script Component

I have an SSIS package which calls a Data Flow Task as part of a loop which iterates different end-point addresses (out of scope). The Data Flow Task has a source Script Component responsible for calling a REST API and creating a row for each…
Bernarzinho
  • 50
  • 1
  • 5
1
vote
0 answers

Precedence constraint in SSIS package performing not as expected

In a SSIS package, I have a simple script checking if the file exists. If it doesn't then the process flow should stop. The script is correctly returning the file exist statement is false And based on the current precedence constraint, it should…
Hristo
  • 11
  • 3
1 2 3
…
11 12