SolvedPrivate

update Oracle Database via SQL 2008

Posted on 2013-01-28
3
33 Views
Last Modified: 2016-02-10
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
Comment
Question by:expoit
  • 2
3 Comments
 
LVL 6

Expert Comment

by:liija
ID: 38827469
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
 

Author Comment

by:expoit
ID: 38827603
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
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38827668
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question