bods: issue in sql transform in bods

[former_member186160]

hi all,

we are trying to use the sql server db concept of hash tables in bods sql transform.

below is a test script, it works fine when used in a script object in a bods DF, but when i use the hash tables concept inside a sql transform in bods, it gives out an error saying

"no columns found" [attached error message]

can anyone please suggest a solution to make this work?

here is a test script: [not the actual concept we are trying to implement but this is just a sample:

SET nocount ON

DECLARE @FirstTable TABLE (RandomInteger INT)

DECLARE @ii INT

BEGIN TRANSACTION

SET @ii = 0

WHILE @ii < 10

BEGIN

INSERT INTO @FirstTable VALUES (RAND() )

SET @ii = @ii + 1

END

SELECT COUNT(*) FROM @FirstTable first

go

[former_member186160 · Accepted solution]

looks like hash tables of sql not supported in bods sql transform.

so i am closing this question.

[jagadishdj1205]

Thank you for the infomation