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 14:48 Go to next message
Yo is currently offline YoFriend
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 14:51 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
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: Mon Nov 24 15:21:52 GMT 2014

Powered by FUDForum. Page generated in 0.05883 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software