Hi All, new to working with SSMA and SSIS...in SSMA for Oracle I have been able to migrate oracle data to sql 2005 with no big issues...I need the ability to refresh the tables on sql with oracle data as it is the production database but our company platform is to use SQL tables with BI tool.
I have completed some work in SSIS but how do I schedule my SSMA project in SSIS to run and update the sql tables on a nightly basis?
Reagrds and thank you to any one that can provide direction and assitance!
Happy Holidays!
Benajmin