I wrote the following (as I realized the data is strictly about pupils up till a certain age):

[note: this will fail when someone will send in stuff like  '20-08-25', but...

• This reply was modified 2 months, 2 weeks ago by blom0344.
• This reply was modified 2 months, 2 weeks ago by blom0344.

Yes, it is due to a lack of understanding how this part of SSIS works, mainly due to working with customers that picked up SSIS in the period when only...

Good question. I do not have much experience with Devops this way. I assume that depoying the packages/project from visual studio directly to the SSISDB repository is a 'native' process....

I basically change the connection string that SSIS builds through the GUID.

Example:

Data Source=.;Initial Catalog=NST;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-BS-{8A0D9E93-E64E-4CC7-B8DD-756F7B0E3CB2}DEV-SQL-NOOT.NST_DEV;

Then I basically change the provider in the connection string.

But if you have a connection...

Message returned after modifying the connection string:

"The specified provider is not supported. Please choose different provider in connection manager. "

The .dll's are present in both the  system32 and syswow64 folders

When...

I do not feel that it would be different. I have no experience with this type of deployment, hence my question. If development and production would not be identical, then...

Okay Phil, that looks like an elegant alternative.

I'll test to check whether any performance difference may exist

Sorry , but I never advocated...

A typical customer would be a small production company where in the past a consultant simply developed on one of the servers within the clients network. Back then it was...

That still wuld require install of all components on the client workstation. As the server mentioned is solely used for staging purposes during the early morning, then database activity is...

Okay, let me rephrase the question: What in you opinion should then be installed on that client (the one RDP'ed against) to get a workable development setup?

And yes, in some...

Don't think so. The customer would be  100 miles around the block and the solution and data itself only existed on the customers server.

No other option than to set up...

I guess this indicates that if you change the account where the 2 services are running under AFTER getting them up or while installing, then the account that  is used...

The error table contains 10.000 entries, but the following message seems the most relevant?:

Microsoft.SqlServer.DataWarehouse.Common.Security.MppSecurityException[107035:1]: 107035;Dms authorization failed due to [NOOT\nootbeheer] is not member of group [PdwDataMovementAccess]

at Microsoft.SqlServer.DataWarehouse.DataMovement.Common.Security.DMSSecurityProvider.RunSecurityRoutineGetNegotiateStream(Stream stream)

at Microsoft.SqlServer.DataWarehouse.DataMovement.Common.Security.DMSSecurityProvider.RunSecurityRoutine(Stream stream,...

The only thing in the logs is the message : Failed Stream Scan.  The DSN is working when used in conjunction with a linked server query, so authentication should be...