The Oracle Attunity drivers are specific to Enterprise and are faster than the standard oledb/odbc drives supplied with the Oracle client.
Whether it justifies the extra cost is hard to...

OP seems to be gone.

I didn't post any idea or sugestion as I believe that what the OP is trying to achive is to execute the sql and...

I don't get the "4" . As far as I get it it should be 3
first date
first 3 are true - this is a consecutive 3
next one...

you need to escape the single quotes for that field - so 'test' becomes ''test''

A percentage is just a decimal type with X integers and Y decimals.
Most cases will store percentages as decimal (9, 4)  but this is always going to depend on...

I assumed you had the database already on 2017 instance.

you will need to create it first - I do not think you will be able to create it...

As far as I can see from the dump the issue was on wow64cpu.dll so going to be hard to identify the exact issue.

You may wish to play...

Most likely some values are null.

try and create a new table without any of the constraints e.g. set all to null and do not have any of the...

can be further simplified
; with mycte as
(SELECT a.MemberID
      , STUFF(
      (SELECT ',' + p.ProgramName
       From MemberProgram...

Can you provide sample tables and data on a consumable format as well as desired output.

although I think I know what you are after the above will not...

Good to know it was my expected "error".

It is a pain for those that don't know better - but in terms of security this is how it should...

you need to change your code to send a string, not a list
something like (untested and not necessarily correct from a syntax point of view)

Cmd.CommandText = "SP_Insert_WC000311A_PremFormData"

can she really not do it or does she just get a warning stating she may not be able to do it? similar to https://sqlstudies.com/2014/07/10/db_ddladmin-and-the-ssms-table-designer/
or does she get a...