YZlat
asked on
Transferring data from Oracle to SQL Server
I need to export some data out of Oracle database 11g (AIX OS), to SQL Server database on a windows server. THis needs to be automated and done on daily basis.
I have two options:
1) Create a linked server
2) use SSIS package
I am leaning more towards building SSIS package. Can anyone give me pros and cons of using one over another.
I have two options:
1) Create a linked server
2) use SSIS package
I am leaning more towards building SSIS package. Can anyone give me pros and cons of using one over another.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But could you tell me what are pros and cons of one over the other?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
ASKER