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 |
|
bnath001
Starting Member
4 Posts |
 Posted - 2009-08-17 : 14:07:11
|
| Howdy folks,New to SSIS. Here is the situation. Seems to be a very simple task.I need some guidance here. Both the source and destination are oracle tables. I have an oracle table. I need to read data from source oracle table (based on a "where" condition) and insert into another oracle table. How should I go about this? Do I need a Execute SQL task? If there is no "Where" condition I could probably connect to the source oracle table using "OLEDB data source " task.Thanksnath |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-17 : 16:33:05
|
I think there is a possibility to choose "take the whole data" OR "use an SQL statement as data source".
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-17 : 16:35:21
|
| Yes, pretty simple.Grab a Data Flow Task, then a OLEDB Source and a OLEDB Destination, using the Oracle providers. |
|
|
|
bnath001
Starting Member
4 Posts |
Posted - 2009-08-17 : 16:46:39
|
| I tried MSDA0ra.1 and Oracle driverThis is the issue:In the OLEDB source editor screen, I chose the access mode as "sql command" and I am trying to get the data for a specific as_of_date SELECT AS_OF_DATE, DEAL_NUMBER, SCID, FHLB_IDFROM ODS.V_ADVANCES_EOMwhere as_of_date = '31-may-2009'I don't get any data though I have data for that specific period in the table.nath |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-17 : 16:52:43
|
try '20090531'
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Insert data into destination table based on