Posts tagged with: ssis
SSIS Package Parts First Impressions
Reading the way package parts were described in the SQL 2016 release notes I was pretty excited. I remember having hundreds of SSIS packages where the overall structure was fairly redundant, this was before BIML was a thing, and package...
Loading Data into SQL Server From Excel
Oft times trying to use the SQL SSIS Import wizard to load data into SQL server from excel you run into data type conversion errors and have to go through many machinations to alter the offending column data types and...