1

this is a newbie questions... is it possible to write a job that will update my sql (SQL Server 2008) table nightly - from an oracle db? i can't seem to find any tutorials online. please help.

i have already created a ODBC connection in the Data Source Administrator....

Madam Zu Zu
  • 6,437
  • 19
  • 83
  • 129

1 Answers1

2

You could setup your Oracle database as a Linked Server and then create a SSIS package that performs the update. This SSIS package could run on a schedule (Job).

Juice
  • 41
  • 1
  • 5