Hi ,
I have created a sequence in SQL Server DB , and wants to call it ( NEXT VALUE FOR Test.CounterSeq ) and assign it to a column in Formula tool and write to DB with In Database tools.
But I am getting error " No Columns Returned."
Please help.
Thanks,
Preethi
Could you use a formula in the In-DB formula like ROW_NUMBER() to generate this new column with a record ID?