VERIFIED SOLUTION i
X

Resolve no column retrieval by clicking 'Get Columns' button for SQL Query and OLEDB transform in Sagent

Issue

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.

Cause

This is a legacy behavior found in Sagent v6.5, v6.7 and v6.8 as well.

Resolution

UPDATED: November 10, 2017


As a possible workaround, use 'SET NOCOUNT ON' with any complex query used in the SQL Query or OLEDB transform

Environment Details

Product Feature: Design Studio
 

Downloads

  • No Downloads