This wiki is no longer being updated as of December 10, 2025.
  • In an effort to make our documentation better for our users, we are consolidating and streamlining the documents.
  • Please see our new, updated documentation at: Melissa Docs or https://docs.melissa.com/

FAQ:SSIS:Known Issues

From Melissa Data Wiki
Revision as of 19:13, 5 March 2014 by Joseph (talk | contribs) (Created page with "__FORCETOC__ ==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 Ma...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.


Future Resolution
We will be adding a fix in a later build to trim the trailing white spaces for Date Inputs.
Retrieved from "http://wiki.melissadata.com/index.php?title=FAQ:SSIS:Known_Issues&oldid=3296"