Thanks for the replies...

@sue:  Development and Production are on the same server, differentiated by separate databases.  Probably not best practice but not under my control.

Further steps taken:

* Updated SSDT to 17.4
* Updated DacFramework to 17.4
* Installed DotNet Framework 4.7.1
* Installed DotNet Core SDK 2.1.4

* Created a simplified...

Ok, perhaps my previous post was 1) too broad, and 2) too long.

I'll simplify:

1) Should I use MERGE, or are there (still) bugs?  Please frame your...

@TheSQLGuru and

Further information...

If I save my SP in master, named sp_MoH_GetColumnList, and marked as a system object, then this works:

EXEC dbo.sp_Moh_GetColumnList 'content.DIAGNOSIS', @debug=1

But this fails:

I've written this SP:

ALTER PROCEDURE [dbo].[sp_MoH_GetColumnList]
( @Table    SYSNAME
, @Columns   VARCHAR(8000) = '%'
, @Types    VARCHAR(8000) = '%'
, @Delimiter   CHAR(1) = ' '
, @QuoteChar  ...

I'm still interested in what you think is the best approach.

However, as I've developed this further, I think I'll need the first approach.  I forgot you can't use...

Hi @Sue_H,

I had to reinstall SQL Server 2014 Developer Edition yesterday, and think I've found the issue.  

I think there is a GPO that controls "Logon...

Hi Phil,

Summary: I've got this working now.

Details: I'll provide some details in the chance someone in the future finds this post via search. ...

Hi Phil,

Thanks for your reply.

I've uploaded a test SSIS solution to https://1drv.ms/f/s!AtQzpRq7KAUEgdVJfZEdxIadQekW-w with public access (expires in 30 days - 15Sep).  I've developed it...