I keep getting the error
The number of failing rows exceeds the maximum specified
Insert error, column 53('DateX', DB_TYPE_DBTIMESTAMP),
status 6: Data overflow. Invalid character value for cast
specification.

I have the following code in my VB script to capture
invalid dates but it's not working:

if isdate(DTSSource("DateX")) then
DTSDestination("DateX") = DTSSource("DateX")
elseif not isnull(DTSSource("DateX")) then
DTSDestination("DateX") = FormatDateTime("01/01/1960")
end if


Thanks in advance help.

SQL Server is not interpreting the date correctly. Try using this variation

Formatting Character Data into Datetime fields
(http://www.sqldts.com/default.aspx?249)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Cathy Emmons" <hseutility (AT) aol (DOT) com> wrote