Top "Script-component" questions

The Script component hosts script and enables SSIS package to include and run custom script code.

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 …

ssis script-component
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 …

sql json ssis buffer script-component
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 …

c# visual-studio ssis json.net script-component
Reading object variable values in SSIS script component source

Is it possible to read object variable values in SSIS script component source? I have a variable, of type Object, …

ssis script-component
Reading CSV file in SSIS Script Component task

I have created a transformation to copy data from CSV file to SQL Server table. Since my CSV file is …

c# ssis script-component
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 …

sql-server ssis sql-server-2012 script-component
Executing Stored Procedure for each InputRow + SSIS Script Component

In my Script Component, am trying to execute Stored Procedure => which return multiple rows => of which need to …

c#-3.0 ssis script-component
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 …

ssis database-connection script-component
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 …

ssis script-component