Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSIS Importing A Null DateTime Problem Expand / Collapse
Author
Message
Posted Friday, April 26, 2013 12:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 26, 2013 12:10 PM
Points: 1, Visits: 0
hi,
i ran into same issue. I spent sometime trying to understand and fix it by redesigning tables and other ways, but to no avail.

So I included a Execute SQL Task in my SSIS which updates the table, updates all the records with '1753-01-01 00:00:00.000' to NULL.

I know this is quite a while ago, hope this helps people in the future.
Post #1447121
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse