MicrosoftHi, I have visual studio 2019, TTU 16.20, and Microsoft Connector 1.0.
I was able to use the Microsoft connector to pull data out of the Teradata and write to another database successfully.
I can find the TD table I want to write to, in the Teradata Destination.
However, I'm having issues now attempting to write to Teradata due to the ErrorTableName property in the Teradata Destination. If I leave it blank, it attempts to create the error file in my user database, where I don't have any space allocated. If I add it without quotes, like databasename.tablename it tries to prefix the database name with SSIS_. If I add it using quotes like "DATABASENAME"."TABLENAME" it doesn't like the period between the database and table. If I just use the database between double quotes it tries to add LOG to the end of it or at least I'm assuming it isn't jumping to another error.
Is it actually trying to add LOG to the end of the value in ErrorTableName and how can I identify the database and table name to use for the error table when using the Teradata Destination to get it to work?
Thanks!
