Under our old DTS packages, bad data (like 32-12-2009) would be inserted into our tables as NULL values. However, in SSIS, it is just being skipped and never added.
Before I go the route of setting up reject files and stuff like that, is there anything I can do to tell SSIS that if the data won't jive, to insert its value as NULL?
Thanks!
Michael
P.S. This is being imported from a text file.