August 26, 2008 at 4:46 pm
I am going to start off hoping that I state the question so you can understand.
I have an xls spreadsheet that carries RFID Data, I need to put that into a SQL table in the database. Here is what I face. The RFID data has a column that is equal to a column in another table that relates to the table I am trying to go into. Here is what I want to do.
1. Look at the excel spread sheet for the ID number
2. Lookup the information in a parent table for that number
3. If those numbers are the same for a record in the database populate a filed in the child table (not the parent table.
xls --> (parent table(look up field to match to xls)--> where it matches put the data in the child table.
Am I using the correct transformation object? Need some suggestions
August 27, 2008 at 5:17 am
The simplest solution will probably be to load the data into a table and then use a stored procedure to populate the child table.
Barring that, a lookup will handle the part about finding the record. Make sure you set the lookup to ignore the error when it does not find a record. Then, use a conditional split looking for records in which your looked up field is not null - from this branch you will be able to do your inserts.
I hope that made sense.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply