I haven't got any experience of this in 2014 or 2016, but in 2012 I experienced a lot of issues if the amount of data in the SSISDB was fairly...

"The client experience"

To be honest, we may have to stick with that option.

Yeah it sounds a little different.

I'm starting to think we'll have to create a custom security extension to facilitate this. It just sounds quite complicated.

Integration Services is installed on the server.

I guess I could try an un-install and re-install of that specific component.

Thanks for the info.

I'll have to look at this to see what the best option is.

I thought I'd provide a brief update to this issue.

This appears to have been some kind of issue using an ADO.NET data source in my SSIS package. After changing this...

So I've been experimenting with this ETL and I'm struggling to get much of a performance gain. I'm currently testing one of the tables that has a little over 2M...

Sorry I should have specified that.

It's an ADO.NET connection to an Ingress database and the query just grabs data from one table according to a date condition that is indexed.

Thanks for pointing that out, Jeff.

The process is using SSIS but I believe it has been set up quickly just to get it working, not necessarily with performance in mind....

Thanks for all the feedback.

The table I have the biggest issue with only has a clustered index and one NC index. There are around 13M rows that get INSERTED...

Thanks for the reply.

I had seen that article but also read a few which suggested disabling alll the indexes.

I guess for now I'll just concentrate on disabling the NC indexes.

Thanks, Jacob!

I assumed it was something along those lines but thank you for clarifying.

That seems to work perfectly!

Thanks for the help with that.

Yeah that's what I need.

I'll do some more testing so my function is similar to the one you tested.

Sorry I should have included that from the outset. Below is the code I'm using:

/****** Object: ResourcePool [pReadIntentAccess] Script Date: 3/07/2015 8:33:46 AM ******/

CREATE RESOURCE POOL...