GT Subset Create Table as Select not working as expected for Build MS SQL Direct Insert scripts
book
Article ID: 272636
calendar_today
Updated On:
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.