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

SSIS package not reading thru all excell worksheets in a workbook

I am troubleshooting an old SSIS package with a script component written in vb. It essentially connects to an excel workbook and reads thru some of said tabs. It will randomly read thru maybe 1, 2 or in the rarest case all of the tabs, but mostly…
yaly_cu
  • 65
  • 1
  • 1
  • 3
1
vote
1 answer

Split multi value column into multiple records

I am trying to split multi value column into multiple records in script component of ssis. I have one column with the name of the actors and the other - with the films they starred (separated by comma). Now I want to split the information so that…
Olga
  • 13
  • 2
1
vote
1 answer

SQL Server Script Component to connect and Make a Destination

I hope I've added this to the right part of the forum - it's about SQL Server Visual Studio 2017 using a Script Component with a source table I've created and want to bring into the Project. So, I have a SQL Server SSIS Project built in Visual…
Peter Boothby
1
vote
2 answers

How to make a Script Component Failure in Data Flow Task?

I have a requirement that is columns validation in the Script component. If the column value found null it should be stopped task with red cross mark and then the task should be the exit. I have used below code to fail the script component task. But…
gopim
  • 35
  • 6
1
vote
1 answer

How to access variables in ScriptComponent in a DataFlow task and assign to a local variable

I am trying to access the variable RowCount. However, I can't do : since its assign value as 0 to row count even if have a result set var rowCount=this.Variables.RowCount;
NAGARAJA H I
  • 149
  • 3
  • 11
1
vote
0 answers

Import JSON Files to SQL Server with SSIS

The JSON file has 2 parts (Nested) and I just could import the first one I don't know why, any idea for this? The first column from the second part showed me NULL in database This is the JSON file format: My code is: public override void…
Leo
  • 19
  • 4
1
vote
1 answer

unable to generate BIML for script component

I am trying to create a simple flow using the BIML tag, but it does not work for me! if I create the data flow manually, then it works perfectly fine! my data flow has: SRC > SCRIPT-COMPONENT > TGT the only logic that I…
user9660395
  • 13
  • 3
1
vote
2 answers

SSIS Script Component Source: How to add error output

I have created a script component (i.e., data flow) that is of the source variety. How do I create an error output that captures both the errorColumnName and errorDescription? The only implementation of creating an error output for a script…
J Weezy
  • 3,507
  • 3
  • 32
  • 88
1
vote
1 answer

SSIS script component as source Null value

I have package in SSIS that loads data using adomd.Net from essbase cube. With 2 columns package works fine, but when I add 3. column package fails. Error message says: Object reference not set to an instance of an object. Third column in the…
ALdo
  • 75
  • 2
  • 13
1
vote
1 answer

To make a Script Component to dynamically assign a data type based on the value from a text file

I have a task of loading data from a .txt file to SQL Server table using Script Component in SSIS. I have loaded that successfully using a script. public void Main() { //Declare Variables string SourceFolderPath =…
Krishna
  • 36
  • 9
1
vote
1 answer

Updating table in SSIS script component

I have table in database with these columns ID | Fact | Date And in column Fact I have only NULLs. I want to use Script Component to update data in this table. Is there any way to do that? Note: I can't use SQL statement because of query…
Indigo_heart
  • 129
  • 11
1
vote
1 answer

How to insert Ticket Number(lookup field) to MS Dynamics CRM Pricing Approval Products(Custom entity) using ssis's script component

I need to create or update Ticket Number lookup field in Pricing Approval Products. This ticket number(lookup field) is linked to Ticket(text field) in another entity named as Pricing Approval Tickets. This is my code in script component. public…
xChaax
  • 193
  • 5
  • 27
1
vote
0 answers

Adding Script Component to VS2015 generated package doesn't run on SQL Server 2016

We are upversioning from SQL 2012 with a BIML-generated package containing a script component. We're receiving an error that I am able to reproduce in a fresh project without BIML. The error is: Failed validation and returned error code…
Suraj-C
  • 11
  • 2
1
vote
1 answer

Derserialized JSON with NULL values to Output Buffer C#

I am trying to return a JSON dataset that looks like the following. Let me caveat this by saying I am restricted to Visual Studio 2010 and .NET 4.0. how do I either output the NULL or convert to blank? "Application": { "AppID": 3119385, …
Lucas Perrett
  • 423
  • 1
  • 6
  • 16
1
vote
1 answer

SSIS Script Component JSON DataContractJsonSerializer

Edit - 5/8 Json sample: { "data": [ { "evidenceId": "9999A999-9D99-4411-8819-DD55D9DDD55D", "status": "Active", "title": "Video 2017-04-30 2354", "idExternal": null, "description": null, "dateUploaded":…
Leslie
  • 3,604
  • 7
  • 38
  • 53
1 2 3
…
11 12