Import data from an SSRS report via SSIS package
- by Chris
First, I ask that you not ask 'why.' In the famous words of Tennyson "Ours is not to reason why. Ours is but to do and die." It's one of those, "This is what you have, deal with it." situations.
The source data comes from SSRS report. The goal is to load the data into a database via SSIS. The hopeful goal is to avoid human intervention in having to download the SSRS report into Excel or CSV.
There will be complex SSIS processing from there on out.
Any suggestions are humbly appreciated.