FAQ:SSIS:Known Issues

From Melissa Data Wiki
Revision as of 19:19, 5 March 2014 by Joseph (talk | contribs)
Jump to navigation Jump to search

SSIS: Matchup - Date Keys are Not Being Built Correctly

When using the Component Type: Date in your MatchCode, Date Keys sometimes do not get built in the MatchKey. This is due to a conflict in the expected input format for Dates. Date Inputs should be in the format 'yyyMMdd'. This becomes problematic particularly for some DBMS. SQL Server for example may have a Date Column defined with char[30]. This causes trailing spaces to be included in the Date Input which conflicts with the expected Input Format, causing the Date Key to not be built.

Future Resolution
We will be adding a fix in a later build to trim the trailing white spaces for Date Inputs.