SSIS- Get count of the oracle tables in SSIS

• laxmikantareddys

  SSC Rookie

  Points: 42

  More actions

  August 16, 2011 at 8:50 am

  #243190

  In SSIS , 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 ??

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  August 16, 2011 at 9:03 am

  #1369133

  Maybe change your query to return 'true' (has data) or 'false' (no data) instead and build your precedence constraint accordingly.

  ---