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

Pablo,

Following your syntax enabled me to define the external table.

But somehow is does not yet allow me to query it:

Msg 8680, Level 17, State 1, Line 1

Internal Query Processor Error:...

The actual error message:

Msg 105082, Level 16, State 1, Line 21

105082;Generic ODBC error: NativeOdbcConnection.Open, error in OdbcConnectionCreate: SqlState: 08004, NativeError: 1, 'Error calling: SQLDriverConnect(this->_hdbc, NULL, (SQLWCHAR*)connectionString, SQL_NTS, NULL, 0, &cbConnStrOut,...

I have 3 seperate DSN's on the SQL server instance , each pointing to a database on the BBj server. So I would have expected to point to the DSN...