ETL and Data Integration tools - Modern ETL software for everyone
|
Welcome,
Guest
|
How do I insert a specific value into MSSQL field
(1 viewing) (1) Guest
|
TOPIC: How do I insert a specific value into MSSQL field
How do I insert a specific value into MSSQL field 2 years, 11 months ago #660
|
The original file (delimited text) that I am reading has 6 fields to make up a single record. I have mapped the records all using the transformer to the appropriate MS SQL table. There however is a 7th field in the record which isn't part of the intial text file, which we use for grouping together the data (resort_id). This field usually contains an integer (in this case, the integer will be 1). How do I write that integer to each record along with the other fields that are already part of the record. What I need to do is create a field value to go into the MSSQL record.
 |
|
|
Re:How do I insert a specific value into MSSQL field 2 years, 10 months ago #662
|
|
|
|
Testimonials
Our prior imports were done using VB. Our VB expert retired. No one in my group knows VB. So Visual Importer was the answer to the lack of VB skills problem my group experienced.
Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston
Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston
User Login
Our customers
 |
|
|
|
|
 |
