SSIS SQL Server to Teradata: TPT Stream requires CREATE MACRO access in Teradata?
I'm using the Microsoft Connector for Teradata v2.0. While using the "TPT Stream" operator within SSIS I am trying to load a Teradata table which has existing records. I receive a Teradata error that says "CREATE MACRO" access is required on the Teradata side. Is there any other way to load a non-empty Teradata table with this connector without requiring the create macro access? Will this ability be available in future versions?