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
3
votes
1 answer

How to manage SSIS script component output columns and its properties programmatically

I am developing a source in SSIS VS 2017 which calls REST API using script Component and serialises JSON and provides records which I am storing in SQL Table. While designing I need add output columns which are 200+ manually and set properties like…
user11060917
  • 37
  • 1
  • 8
3
votes
0 answers

SSIS Script Component takes long time to Open on Edit | VS 2017

When I edit a script component on SSIS, it takes upwards of 30 seconds for a new instance of visual studio to open so I can edit it. This makes debugging and making small changes very time consuming. I will be using SSIS packages a lot going…
AlanPear
  • 737
  • 1
  • 11
  • 32
3
votes
1 answer

JSON to C# Class Names with Spaces

I am returning the following JSON Class from an API Request "Top Uncommitted Spend": [ { "AccountID": 99999991, "H1": "Liabilities", "H2": "Top Uncommitted Spend", …
Lucas Perrett
  • 423
  • 1
  • 6
  • 16
3
votes
1 answer

SSIS Script Component Source - Read from SharePoint 365 List via Odata

I apologize if my question is not adequately described. I am a .Net / C# / SSIS newbie. Also apologize if already answered, I've tried searching here and Google for a few hours without luck. Background: I need to pull data rows from a SharePoint 365…
matwer1
  • 161
  • 1
  • 7
3
votes
1 answer

SSIS Script Component or Script Task Write To Job History Log

I am using SQL server 2008 R2. I have a scheduled job that executes an SSIS Package - running in SQL Agent. I want to log messages that happen in the scheduled job. I want to log messages from Script Component or Script Task. I do not want to log…
Simcha Khabinsky
  • 1,970
  • 2
  • 19
  • 34
3
votes
1 answer

Version control for Script Component C# files in SSIS

I have this problem using version control with SSIS. When I am writing a Script Component it gets checked into the version control as binaries and not the C# file (it's understandable though). So next time I make a change in C# file of the Script…
Kumar Vaibhav
  • 2,632
  • 8
  • 32
  • 54
2
votes
1 answer

ssis script component error connecting to Sharepoint

I have c# code connecting to and pulling data from a SharePoint list working fine when called from a console application configured to run as 64bit. When I invoke the same code configured for 64bit, I get the following error within an SSIS script…
user3535647
  • 45
  • 4
2
votes
1 answer

SSIS: How to debug a custom assembly that is referenced inside of a script component

I am able to debug custom components that are added to SSIS through Visual Studio's Attach to Process feature. However, is it possible to debug a custom assembly while it is being executed inside of an SSIS package's script component (i.e., C#…
J Weezy
  • 3,507
  • 3
  • 32
  • 88
2
votes
3 answers

How to use a SSIS Dataset inside Dataflow Script component for Source?

I'm looking for a way to use my Dataset variable in Script component of SSIS data flow task, here is what I tried till now My First Task is Execute SQL task (CData PostgreSQL Task) This would run a Postgre query and store the result in a variable…
MJoy
  • 1,349
  • 2
  • 9
  • 23
2
votes
0 answers

Counting Emails in inbox from SSIS (C#) - The remote server returned an error: (401) Unauthorized

I am trying to create a connection to the ExchangeService from a script component (C#) in SSIS to be able to count the total number of emails in an inbox. My error comes when I try to use the connection - so far I've been testing the connection to…
Shadow336
  • 21
  • 1
2
votes
1 answer

Increment Variables in Data Flow task

I have a large text file which has multiple different rows within it. I am using a Conditional Split which looks at the row type (Field 1) and then takes an action, mostly trying to increment a variable, split the single row into multiple columns…
JbP
  • 45
  • 3
2
votes
2 answers

SSIS Script Component reading web data but not creating the Output0Buffer object

I am using SSIS with a Script Component to retrieve data from a web service and put it into SQL Server. However, in the output, the Output0 object (default name) is visible on designtime but is no object at runtime. #region Namespaces using…
P Oltergeist
  • 44
  • 6
2
votes
1 answer

SSIS error- Binary code for the script is not found

I have run into this strange SSIS error where my script component on the server keeps failing with the error -"The binary code for the script is not found. Please open the script and make sure it build correctly". The script build absolutely fine…
Saugat Mukherjee
  • 778
  • 8
  • 32
2
votes
2 answers

SSIS Script Component DT_TEXT newline not correctly stored in table

I need to store a large text created in the SSIS package Data Flow Script Component to the destination column with data type varchar(max). I use therefore as an Output Column text stream [DT_TEXT]. Inside the C# script I call the method…
iStan
  • 78
  • 1
  • 11
2
votes
1 answer

Error in SSIS package when script component is trying to retrieve errorCode and errorColumn-[SSIS.Pipeline] Error: No object exists with the ID 0

I have a SSIS package where I am using a script component in DFT to retrieve the error column and error description from an insert into a SQL table. My code is below. However, after the DFT is done (it completes all its steps) the package cannot…
Netta G
  • 53
  • 1
  • 5
1
2
3
…
11 12