I am hoping someone can advise the best way to store data outside of the sql server for future use.
I would like the ability to query this data at a later time when there is no associated sql server
some reporting tools, like crystal, allows you to report from flat files.
i need to extract full tables of data.
I queried on table for just 1 months data and the row exceeded the excel storage ability.
so keeping them as flat files is not an option.
i would like to know if anyone has encountered this issue and if they have a solution.
i am looking into SSIS but i am not familiar with that tool to make a decision if it is the way to go.
does anyone have any suggestions on the best way to handle this?