Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » CSV import with auto-generated primary key
CSV import with auto-generated primary key [message #677448] Wed, 08 June 2011 10:48 Go to next message
Yo is currently offline Yo
Messages: 10
Registered: July 2009
Junior Member
Hi,
I load a CSV file into a table but DTP insists on each row in the file
having a primary key. But I want DTP to genewrate that.

The rows in the CSV file do not have a primary key. In the destination
table, the first column is defined as a non-null, auto-generated primary
key. I was hoping that when the first column in the CSV is empty, that
DTP will auto-generate that column. Instead, it gives and error stating
that a null value is being assigned to a non-null column.

Is there way to get DTP to auto-generate IDs during CSV import?

I am using DTP 1.9.

Thanks, yo
Re: CSV import with auto-generated primary key [message #690467 is a reply to message #677448] Wed, 29 June 2011 10:51 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Yo, I don't believe there is a way to do this currently. Can you create an enhancement request?
Previous Topic:Connection error to SQL via BIRT viewer
Next Topic:New connection profile to Sybase ASE database..(problems)
Goto Forum:
  


Current Time: Thu Jul 31 21:46:46 EDT 2014

Powered by FUDForum. Page generated in 0.01768 seconds