January 18, 2014 at 3:01 pm
create a table, within it you may need to create ID column. add values/data from a file. Then compare the values for the already inserted values (e.g. if Product ID already exists). If the value already exists, you will need to enter the value for the next column (a bit more advanced SSIS
I am new to ssis, I am able to create a table with column id and add values to it from a file from ssis package but I am not able to solve the highlighted part. this is a bit urgent, hope someone helps.
Thank you.
January 18, 2014 at 4:03 pm
gopisridhar,
Can you provide the sample tables/data? I'm not sure I understand your question completely when you say next column.
Are you are trying to update the the existing rows and insert new rows? If yes then you could use a lookup transform and update the records that match and insert the ones that fail.
Mike
January 18, 2014 at 5:22 pm
Thank you Mike.
Let me modify my question and make it clear.
1.Create a table with columns ID, Firstname, Lastname in any sample database.
2.Insert values into the table from and SSIS package (say, Excel source to OLEDB destination)
3. Now, every time you try to insert values into the table from SSIS package,
i) we need to check if the data already exists in the table
ii) if the data exists, the newly inserted data should get inserted into a new column of the same table.
January 18, 2014 at 6:00 pm
This article should have most of the info that will help you accomplish what you asked.
http://www.sqlservercentral.com/articles/Stairway+Series/76390/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply