Created a simple ETL job with source,sql transform,destination. Able to load the data for all the tables but except One table.
When click and view data on source table, can not be able to load the data.
But can see the data in database. I am using the same login credentials for db and data store.
Thanks in advance.
kiwi (BOB member since 2009-06-17)
Is it a different data store? Is it ODBC? Do you have the same ODBC connection on both the client and the server machines?
eepjr24 
(BOB member since 2005-09-16)
I am using data store connection for bods. Not using ODBC.
Shall use ODBC?
kiwi (BOB member since 2009-06-17)
Need more information then. Version of DS and DB, DB type, OS, etc.
eepjr24 (BOB member since 2005-09-16)
Version of DS: BODS3.1 (12.1.1)
DB: Oracle 10g
DB type: DBMS
OS: Windows2008
kiwi (BOB member since 2009-06-17)
Hrm. Have you tried deleting and re-importing the table from the data store? Tried pulling just the one table in a different dataflow? Do you get any warnings or errors?
eepjr24 (BOB member since 2005-09-16)