How can we update 10 tables by comparing with a text file using packages in ssis 2008?
Hi, I have 10 tables each corresponding to patients list in each ward in a hospital with column names patient name and status At the end of each day a text file with details regarding the patients who got discharged on that day is produced We have to compare the patients list in this 10 tables with text file one by one and the status of the patients who got discharged on that day have to be changed to discharged How can we implement this using packages in ssis 2008 Waiting for quick reply Thanks in advance.
If I were you I would try to import the text file into a table. Then by adding proper indexes on that table, it would be much easier and more optimized task to compare and update the tables as per requirement. Hope it helps.