Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2010-11-17 : 05:14:23
|
| Hi GuysI'm a newbie to using conditional splits in SSIS and encountered the following problem.I am trying to create a conditional split to check if one date doesn’t match another, using the following expression:((ISNULL(Registered_DateTime) ? "" :Registered_DateTime) != (ISNULL(Dest_Registered_DateTime) ? "" : Dest_Registered_DateTime))However it doesn’t seem to be working, I’ve highlighted the error it states that data type DT_WSTR and DB_TIMESTAMPS are incompatible data types.I’ve tried putting different CAST expressions in but with no luck.Anyone have any ideas on what I could do?Thanks |
|
|
|
|
|
Conditional Split Problem