GT Subset Create Table as Select not working as expected for Build MS SQL Direct Insert scripts

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to create subsets by using the MS SQL Direct Insert scripts and selecting Create Table as Select option while doing it. It doesn't seem the generated SQL scripts correctly. They fail to properly check if the tables exist on the target and create and insert the data there. The image below shows how my options are selected. 

 

While running the insert script, we see the following error:

Error executing insert SQL

Changed database context to 'DatabaseName'

Msg 301, Level 11, State 5, Server XXXXXX, Line 3

Cannot drop the table 'DatabaseName.Schema.TableName', because it does not exist or you do not have permission.
Inserts Complete

 

Solution Engineering has determined the SQL Server insert script is creating an extra "," during the generation of the script for L0 temp table, also the Use database should be the target database and not the source one.

 

 

Environment

Release : 4.10

Resolution

This is resolved in GT SubSet 4.10.125.0. The patch is available for download in the TDM Patches page.