SSIS 2005 and datetime issues with null value

• sridevi sriraman

  Mr or Mrs. 500

  Points: 580

  More actions

  May 24, 2009 at 8:27 pm

  #137976

  Hello All,

  I am experiencing a strange issue. My package is executing an sp. SP has 3 parameters. I am passing one int value from package and leaving the default value for the remaining two. One among the defaulted value is datetime value and defaulting it to null. Later in the procedure i am assigning a different value. After that I am checking this datetime value to be greater than another datetime and trying to execute a piece of code. But this piece of code is never executed proving that the datetime values set by me and then conditionally verified are not working good.

  I also have another package that does not pass any parameter to this SP and that package is working fine. I mean the datetime condition is working good in this case and my piece of code based on this condition is executed successfully.

  Is there any known issue while passing parameters through SSIs package to stored procedures.

  Thanks.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 24, 2009 at 9:44 pm

  #999551

  Could you post the code, please?

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]