SSIS Package not Retrieving Metadata From Teradata Stored Procedures
SSIS package throws an OLE DB Source Error 79872: No column information was returned by the SQL command. We are using OLE DB Provider for Teradata 14.1.
We have been calling Teradata macros successfully with SSIS packages but wish to use Teradata stored procedures instead to improve performance. The SSIS package appears unable to retrieve metadata from the select statement in the cursor and thus is failing.
Has anyone managed successfully to have a SSIS package call a Teradata procedure and capture data returned from that procedure?