Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ShilpaGuru
Starting Member
1 Post |
 Posted - 2009-06-22 : 01:26:42
|
| Hello Experts,I am very new to SSIS. My doubt goes,File1 has 20 records. Its data loaded to database. If once again same file is loaded for importing its record to database, I want all these 20 recordds should go & update existing records of database.I have a unique column ( say Column a). How to achieve this?Explain step by step as I am very new to this.Regads,Shilpa G |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-06-22 : 05:25:14
|
| Use the Lookup Transform if you have more records in the file.orPopulate the loading table(temptable) with the file contents and Write an update statement by joining the Original Table and temp table Key(colA) and use it in the execute SQL taskhttp://www.sqlserver007.com |
 |
|
|
|
|
|
How to update entries of Database?