I extract data from a sequencial file that has 4 columns and then I insert it in a table but it doesn't have an id column,
What doesn't come to my mind is how to extract the information of the sequencial file and add one row which needs to be an id column and then insert the data in a table.
How to put an id column to a group of data extracted
Moderators: chulett, rschirm, roy
Sorry, I'm a little lost.
Are you saying your target table has an "ID" column but your source flat file doesn't so you need to assign one during the load? So, when you said "add one row" you actually meant "add one column"?
Before we start talking the specifics of a solution, can you clarify something please? First I want to make sure we are talking about a Server job and second tell us what database you are using and what datatype this ID column is. Thanks.
Are you saying your target table has an "ID" column but your source flat file doesn't so you need to assign one during the load? So, when you said "add one row" you actually meant "add one column"?
Before we start talking the specifics of a solution, can you clarify something please? First I want to make sure we are talking about a Server job and second tell us what database you are using and what datatype this ID column is. Thanks.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers