How to insert into netezza table from SSIS with sequence value

Asked Aug 17 '16 at 15:35

Active Aug 17 '16 at 15:35

Viewed 226 times

I am trying to do a basic dataflow task in SSIS2012 where the destination is a Netezza table. I have a column that I named "Transaction_ID" that I am planning to use as a primary key and I have a sequence ready to populate it (Seq_Transaction_ID). However, I am not sure how exactly to assign the sequence.

For instance I tried making the table and assigning the column to a default of the next value for the sequence and got an error "you can only use a next value function within a target list". I'm also not sure how I would get the sequence into SSIS either.

Any ideas?

Thank you,

asked Aug 17 '16 at 15:35

user3494110

What is the source RDBMS? – Kyle Hale Aug 17 '16 at 15:37
Possible duplicate of [Next value function error](http://stackoverflow.com/questions/17829458/next-value-function-error) – Kyle Hale Aug 17 '16 at 15:39

How to insert into netezza table from SSIS with sequence value

0 Answers0