Is there any method in TPT to build the script without defining the schema of the tables so that I can build one generic script and pass the tablename and databasename as parameter .
I'm trying this:
DEFINE SCHEMA Tables_SCHEMA @SourceTableName;
DEFINE SCHEMA Tables_SCHEMA DELIMITED FROM TABLE @SourceTableName;
Sample job variable file
Is this correct ?
DEFINE SCHEMA SCHEMA_NAME FROM TABLE '<DataBaseName>.<Table/ViewName>';
But if you are using TPT 14.10, please be careful with Data Connector operator and Date datatype.