As a BI consultant we regularly get the question to load 1 or more excel files, with on or more worksheet.All those files have different layouts and columns have different datatypes.
Written by Jamie ThomsonLink to original article — — — — — — — — — — — — — -I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience…
Ever had the problem you want to add annotation to your SSIS package and you hit your ENTER and you don’t get a new line?Try: CTRL + ENTER
Somthing small but really usefulThis creates from a DATETIMESTAMP a STRING with following structure YYYYMMDD(DT_WSTR,4)YEAR(GETDATE()) + RIGHT(“0” + (DT_WSTR,2)MONTH(GETDATE()),2) + RIGHT(“0” + (DT_WSTR,2)DAY(GETDATE()),2)