oracle-databasessisdata-extraction
difference in number of items extracted by SSIS vs. query
I face with a weird issue in SSIS 2016. I have 7928 record in my oracle database and when I use SSIS to extract the same query, it shows me 15982 records. Do you have any idea why it is happening?
my source in Oracle DB 10g and I am using SSIS 2016.
QUERY
SSIS query
SSIS output
Solution
The problem was due to use comments in the query cause the other part of query could not recognize by SSIS.
- Cannot connect to Oracle (oci8) with Apache (FPM). PHP 7.x CLI is OK
- How to use Oracle's LISTAGG function with a unique filter?
- Installing oci8 on Centos 8 running Apache and php-fpm
- Echo sqlplus command without using prompts or scripts
- Talend BatchUpdateException not caught while using tOracleOutput
- data type changes when using AVG in view definition
- Oracle JSON_OBJECT how to have a missing key
- Best way to check if SYS_REFCURSOR is empty
- How can I remove backslash escaped characters from a string?
- Get the minimum value from XML set of nodes using XPath
- How to write pandas dataframe to oracle database using to_sql?
- How to query the return value of RECORD Type of a Function in oracle-database
- Oracle find tablename given an index name
- Oracle - Identify rows that contain chinese characters in a CLOB column
- Is it possible to target a column in table B, based on a value in table A?
- Oracle SQL Developer - How to Display Percents using Color (Not Numbers)
- ORA-01840: input value not long enough for date format SQL Oracle
- How to see all weeks and months by number
- do a select from a potentiel non existing table
- Oracle DB Statistics not accumulating?
- Retrieve result of StoredProcedure that has NO out parameter
- Oracle retrieve only number in string
- in Oracle database, how do I create a table of varchar2 type without length
- How to create a comment to an oracle database view
- How can I confirm a database is Oracle & what version it is using SQL?
- Oracle - junction tables and connect to prior
- Cannot stop/drop job in DBMS_SCHEDULER
- CHECK constraint on date of birth?
- Select without a FROM clause in Oracle
- Resetting the Last_NUMBER in sequence by looking up a value from a table