Jeff Moden (3/1/2015)
Outstanding. Thank you VERY much for the time you've spent on this whether it may have been trivial or not, Eirikur. You obviously took some time to import that bad boy into a "flat" table.Glad to see that it's as complex yet as "simple" as I thought it would be. The fun part will be when they add a month between March and the Total. Would that be "self realizing" or what that require a change to the package?
Doing the same using script tasks and/or script transformations is even simpler and often more robust if properly constructed.
Simplest of all is the ELT method of using the SSIS to import all columns as text into a staging table....
Absolutely agreed on the above and that's the point that I'm trying to drive home on someone.
You really like to throw a spanner or two in the works ain't it :-p, your question is very valid and just, you've hit the bulls eye on the most common reason of why such a packages fail when ELT wouldn't
😎
If you need any more statistics or conformation on why the ELT method is superior to any other, just let me know.
PS. on the time spent, you would do the same!