Hello I have a sample file named "Source.xls" attached here for how I am getting the file from the source.
I want to load this file into SQL server 2008 DB with a order like the target format excel named "Target Format for load " attached here.
I am also not sure if the target is correct as I feel a bit hard to manage the historical data.
I want to maintain the history data for the source file.
Can any one suggest the best way to maintain this type of source data.
Note: I don't have any direct access to any DB except the target DB. This is the only way i can get the data. Please suggest the best way to handle the target structure.