I don’t know about you, but one of the things that drives me to distraction when writing SSIS packages is being forced to use excel as a data source. I’d like to qualify that statement by adding that it’s the use of excel in the face of all reason, to do the job that other software would be better for. Unfortunately though, corporations and people being what they are, they are a fact of life for an ETL developer.
Amazon Link: Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
Continue reading “Excel VBA to prevent user generated errors in SSIS”