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.