How to check if oracle table has rows ?? Variable mismatch??

• laxmikantareddys

  SSC Rookie

  Points: 42

  More actions

  August 14, 2011 at 10:21 pm

  #243178

  In SSIS 2008, I need to check if a source oracle table has any rows if there are rows I need to proceed to next dataflow task where I will be loading data from Oracle source to SQl database.

  I got the count(*) from oracle in Execute Sql task from source but the data is coming as object or String variable and I am not able to type cast that variable to Int to check in Precedence constraint I am getting Variable mismatch error??? IS there any other way to check this ??

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  August 19, 2011 at 4:22 am

  #1370615

  A count(*) should return an integer. Did you use the Single Row Result in the Execute SQL Task?

  You create the variable yourself. Assign it the integer data type and use that variable in the Result Set pane to map the results.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP