• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 55
  • Last Modified:

update Oracle Database via SQL 2008

Hi,
I have application on SQL2008 R2.
I have a form in that application where data has to be transferred  to Oracle Database once the form is completed.

How can I achieve this and can I use SSIS to transfer data ? and how can I trigger the data transfer

Thanks
0
expoit
Asked:
expoit
  • 2
1 Solution
 
liijaCommented:
You can do it with SSIS but its better with batch type of jobs. If the data is not needed instantly in Oracle, you could easily schedule SSIS package to be run once a hour. Or SSIS can also be run from command line, with required parameters, with dtexec utility.
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

For up-to-date integrations MS BizTalk is better product. SSIS is not initially designed to be used like that.
0
 
expoitAuthor Commented:
Do you have any guide where i can create the SSIS package from SQL to Oracle.
and is there a way where I could trigger the data transfer of change of a field.
0
 
liijaCommented:
Creating package for oracle is not different from creating one for SQL Server. You only define the connection to be Oracle for the output.

You could use the dtsx.exe to trigger the package. Read through the msdn ducumentation.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now