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
22
votes
8 answers

Could not load file or assembly 'Newtonsoft.Json' Version=11.0.0.0

I have read a lot of the responses to previous versions of this issue but none seem to work. Every time I open my script component in Visual Studio 2015 (v14.0.25431.01 update 3) it tells me I am missing a reference to Newtonsoft.Json. So I go into…
Lucas Perrett
  • 423
  • 1
  • 6
  • 16
15
votes
1 answer

SSIS - The value is too large to fit in the column data area of the buffer

I'm passing a column of Json data to the script component to process. It went fine until I had a Json data that contains over 600,000 length, then the follow error occurs. I did change the MaxBuffer size to 10MB, and my data is only around 600K…
user3268139
  • 352
  • 2
  • 3
  • 16
12
votes
6 answers

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server

I created SSIS packages and used the Integration Services Deployment Wizard to deploy it out to the server. I'm manually going to the Integration Services Catalog access through SQL Server 2012 and right-clicking and executing my package. However,…
Juc
  • 217
  • 1
  • 3
  • 9
7
votes
3 answers

It's possible to use OleDbConnections with the Script Component?

I'm building an ssis package and I wish to use an existing OleDbConnection inside the Script Component. Here is my code: public override void AcquireConnections(object Transaction) { base.AcquireConnections(Transaction); cm =…
Oscar
  • 13,594
  • 8
  • 47
  • 75
6
votes
3 answers

Conflicting assembly names after copying script components in SSIS

I created an SSIS package (in VS 2013) with a data flow task containing several script components. I needed to add another data flow task that is similar to the existing one so I copied and pasted it into the package and added a precedence…
user2148983
  • 138
  • 2
  • 13
5
votes
2 answers

SSIS Script Component connection

I've been searching for a solution for days now and I still cant seem to find one. I have a problem acquiring a connection in my Script component. I need to query my database to retrieve an Id to be used before I insert it in the public override…
Milo Cabs
  • 503
  • 1
  • 10
  • 24
4
votes
1 answer

Invalid Cast Exception When Reading Data From Excel In SSIS

I am trying to read particular cell values of Excel and store in a table. But receiving an Invalid cast exception. Below is my code in VB Script: Dim oExcel As Object = CreateObject("Excel.Application") Dim FileName As String FileName =…
Ranjan Allen
  • 41
  • 1
4
votes
2 answers

Can I add rows to Output Buffer in SSIS Script Component in PostExecute?

I have a Script Component where I buffer all the rows, then do some processing, and then I want to create the output rows. I tried accessing the Output Buffer object in PostExecute but apparently that's not possible? Gives "Object Reference not set…
Kelly
  • 945
  • 2
  • 18
  • 31
3
votes
1 answer

AddBlobData(Encoding.GetBytes(string)) Only grabbing first Character

I have been trying to assign/append a string to a blob column in an output buffer, on a C# script that's taking a number of input rows, and concatenating them where the related id is identical, passing onto the next row where the is new, and seem to…
Wenlocke
  • 155
  • 4
3
votes
0 answers

SSIS Script Component - Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=x' or its dependencies

I tried many steps for this "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies." After i installed Newtonsoft.Json latest version (13.0.1) and excute my…
Logain Theran
  • 51
  • 3
3
votes
1 answer

ssis package execution succeeds directly but fails via c# code

I have the following code which seems to works OK for executing an SSIS package from c# BUT every time the variable "Resp" returns a Failure even if the package passes when I execute it directly in SSIS. Again, the package contains a Script…
ibexy
  • 609
  • 3
  • 16
  • 34
3
votes
2 answers

SSIS read a System.Object variable and write to it in Script Component...How?

I have a SSIS package which starts with a Script Task which initializes an empty DataTable and assigns it to a user variable. I'm adding some sample rows as I'm still doing development. The variable is called: FlatFileBadRowDataTracker in…
gtrivedi
  • 435
  • 1
  • 7
  • 18
3
votes
1 answer

Import more than 255 Characters from excel to sql server (previous question - how to load text qualifed CSV dynamically to sql server using ssis)

I have a CSV file which has salesforce data and is generated using python API call and i am trying to load the file in MS SQL DB using SSIS. I need a C# script to rectify the issue because the data is not consistent (no of columns and order of…
Amanpreet Kaur
  • 31
  • 5
3
votes
1 answer

Underscores are not reading by script component in Microsoft Integration services

I am trying to create table schema based on columns metadata in Script Component. Its everything fine, but I realized that the metadata columns are incorrect :(. I mean in origin way they should have underscores in names. SSIS is deleting this…
Bartosz
  • 35
  • 4
3
votes
1 answer

writing .dat file into .txt file after encoding using ssis

I have .dat FIle. I need to do some encoding on this file and need o save into a .txt file I am using script component in SSIS. I have used SSIS Script component to impement this . //have declared 2 read write variable FIleLoc and FileWrite string…
user3035090
  • 57
  • 10
1
2 3
…
11 12