Different query result between SSIS and Oracle Sql Developer

Question

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

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]