SQL Server Integration Services often has problems with recognizing & interpreting dates. Often it struggles to figure out what is the Day, Month and Year component. This can cause big problems, particularly if the date needs to be manipulated in some way – such as adding or subtracting dates. Usually the best solution is to deconstruction the original date and then reconstruct it in a format that SSIS will recognize. This post outlines how to use SUBSTRING, FINDSTRING and RIGHT string functions to standardize date formats.
Standardizing date formats in SSIS using SubString, Findstring & Right Expressions.
« Creating dynamic 95% Confidence Intervals in Powerpivot charts
How to update PowerPivots when the underlying source data changes. »