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.
asked Mar 09, 2013 at 04:26 AM in Default
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.
answered Mar 09, 2013 at 01:23 PM