Sequence to be written to Database

[preethisisaac]

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

[bbak91]

Could you use a formula in the In-DB formula like ROW_NUMBER() to generate this new column with a record ID?