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 t...

When I open a Script component, I can choose a Connection Manager from a dropdown list: This Connection Manager has it all, if I had it as an object in the C# code, I would not need to write a har...

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...

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 ...

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 ...

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 b...

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 MaxB...

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.AcquireC...