VERIFIED SOLUTION i
Resolve no column retrieval by clicking 'Get Columns' button for SQL Query and OLEDB transform in Sagent
When a specific query is run, it does not return data and if we click on the 'Get Columns' button the columns are not retrieved in SQL Query and OLEDB transforms.
This is a legacy behavior found in Sagent v6.5, v6.7 and v6.8 as well.
UPDATED: November 10, 2017
As a possible workaround, use 'SET NOCOUNT ON' with any complex query used in the SQL Query or OLEDB transform
Product Feature: Design Studio
- No Downloads