Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sudhanshuntyl
Starting Member
5 Posts |
 Posted - 2009-09-18 : 02:53:09
|
| I am trying to get the data through SSIS package on oracle database and wrote the query on data flow task OLEDB Source.The query is running perfectly on the oracle query analyzer and returning the records on the basis of the given WHERE and ON Condition.But not getting the record while I am running it through SSIS package.I tried the same query with the "ROWNUM" Clause through SSIS for 10 records and getting the records. But for more records I am getting no records and package is not giving any error either, its remains in the running stage all the time. |
|
|
|
|
|
Problem in running query through SSIS in oracle.