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 |
|
AnuVijay
Starting Member
32 Posts |
 Posted - 2011-11-01 : 08:07:54
|
| HiI am using condition split to check the following condition while importing dbase files.Where gl_op_date>=’2011-04-01’ or(gl_op_date<=’2011-04-01’ and (gl_cl_date>=’2011-04-01’ or gl_cl_date is null))GL_OP_DATE <= (DT_DBDATE)"2011-04-01" && (ISNULL(GL_CL_DATE) || GL_CL_DATE >= (DT_DBDATE)"2011-04-01") || (GL_OP_DATE >= (DT_DBDATE)"2011-04-01")I am getting the following error:[Conditional Split [76]] Error: The expression "GL_OP_DATE <= (DT_DBDATE)"2011-04-01" && (ISNULL(GL_CL_DATE) || GL_CL_DATE >= (DT_DBDATE)"2011-04-01") || (GL_OP_DATE >= (DT_DBDATE)"2011-04-01")" on "output "Case 2" (781)" evaluated to NULL, but the "component "Conditional Split" (76)" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row). The expression results must be Boolean for a Conditional Split. A NULL expression result is an error.[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Conditional Split" (76) failed with error code 0xC0209029 while processing input "Conditional Split Input" (77). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.Can you please help me to resolve this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-01 : 11:51:12
|
| check for NULL values in gl_op_date field and convert it to some default date value using ISNULL------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-11-01 : 12:49:23
|
| I would like to filter the records from the dbase file using the following condition.Where gl_op_date>=’2011-04-01’ or(gl_op_date<=’2011-04-01’ and (gl_cl_date>=’2011-04-01’ or gl_cl_date is null))can u help me how to implement this in ssis using conditional split. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-02 : 05:43:44
|
| are there records with null date values coming?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-11-02 : 12:07:14
|
| yes. I want to filter records based on the null value or the date >= 2011-04-01.Can u pls assist me? |
|
|
|
|
|
|
condition split