how to compare data in a table after a weekly load has taken place using ssis
table Create table Host CPU memory
Hostname varchar(120) not null Datetime datatime notnull CPU float notnull memory float notnull start_date datetime notnull (load of the file) End_date datetime notnull (High date) - 31/12/9999
In the above table there is a weekly load happens, after this I had script which got corrupted I have the logic for it, I am unable to recollect the same kindly help please.
After every week load it will compare records based on the hostnames loaded last week with the current week, if there is a match of records(based on hostname alone) then for those records alone will have the end date changed to current load date minus one in the previous weeks load, if it’s not matching then the list hostname which not are matching with previous will be mailed to the stake holder and no change in end date.
Also the current week data will have the end date as high date by default.
Also the count of hostnames not matching with previous week should also be mailed to stake holders.
One more thing I want start_date and End_date will be inserted based on the load date of file.
I am facing a probelm in this as the data is not having the start date and end data in flat file.
Any help on this would really appriciated, if you have the sql script or ssis package kindly mail it to me please at [email protected] or [email protected]
Thanks & Regards Srivatsan