Different query result between SSIS and Oracle Sql Developer

• kferrara

  Old Hand

  Points: 398

  More actions

  June 10, 2015 at 3:28 pm

  #318770

  Has anybody encountered this problem? I'm connecting to an Oracle database via both SQL Developer and SSIS using the Native OLE DB\Oracle Provider for OLEDB. I am running the same exact query in each application but getting very different results. The data columns are the same but the number of rows is different. I am using this "WHERE" clause that I think might be the culprit and using a variable to bulid the query in SSIS. I have validated the query. When I check the data on the SQL Server side and on the Oracle side the dates are within the range. I checked my connections to ensure I am connecting to the same database and I am.

  where o.DB_UPDATED_DATE >= TO_DATE('08 APR 2015 10:02:14', 'DD MON YY HH24.MI.SS')

  Also, I did a query via SQL Developer for one of the IDs returned from the SSIS results and it wasn't in the DB.

  Could there be a problem with the tnsnames.ora file? I have no idea how to continue troubleshooting this. Thanks for your suggestions.

  Karen

• Alvin Ramard

  SSC-Forever

  Points: 41190

  More actions

  June 10, 2015 at 3:37 pm

  #1804528

  kferrara (6/10/2015)

  ---

  Has anybody encountered this problem? I'm connecting to an Oracle database via both SQL Developer and SSIS using the Native OLE DB\Oracle Provider for OLEDB. I am running the same exact query in each application but getting very different results. The data columns are the same but the number of rows is different. I am using this "WHERE" clause that I think might be the culprit and using a variable to bulid the query in SSIS. I have validated the query. When I check the data on the SQL Server side and on the Oracle side the dates are within the range. I checked my connections to ensure I am connecting to the same database and I am.

  where o.DB_UPDATED_DATE >= TO_DATE('08 APR 2015 10:02:14', 'DD MON YY HH24.MI.SS')

  Also, I did a query via SQL Developer for one of the IDs returned from the SSIS results and it wasn't in the DB.

  Could there be a problem with the tnsnames.ora file? I have no idea how to continue troubleshooting this. Thanks for your suggestions.

  Karen

  Just curious ... What's the DB_UPDATED_DATE for the rows not in both results?

  ---

  
  Alvin Ramard
  Memphis PASS Chapter[/url]

  All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

  For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]