|
I am trying to load a csv file into a sql server table. The source file has 4 date columns.I have used derived col transformation to change data from string to datetime value before i insert them to SQL server DB. Now,one of the column in Source has values '0000-00-00'. I am new to SSIS and don know how to handle this. Because of this weird value , the load operation fails saying " Data conversion error". Whn i configured the error rows to be redirected into a table , then the insert operation was successful but only with half of the record which it has in the source file, Kindly help me in this.
(comments are locked)
|
|
You could use something like this to insert nulls for those known invalid "date" values. If you need more complex features like the ability to validate incoming data as a certain data type, I recommend using a script component instead. Perhaps ISDATE (http://msdn.microsoft.com/en-us/library/ms187347.aspx) would be a better choice validation wise?
Apr 26 '10 at 03:21 AM
Matt Whitfield ♦♦
Unfortunately, the ISDATE T-SQL function is not available in an SSIS expression.
Apr 26 '10 at 10:04 AM
Tom Staab
(comments are locked)
|
