<div>
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.<br />
<a href="http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx" rel="ugc">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/ms1628<wbr />10(v=sql.1<wbr />05).aspx</a><br />
<br />
For up-to-date integrations MS BizTalk is better product. SSIS is not initially designed to be used like that.
</div>


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 [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.

<div>
Do you have any guide where i can create the SSIS package from SQL to Oracle.<br />
and is there a way where I could trigger the data transfer of change of a field.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have application on SQL2008 R2.<br />
I have a form in that application where data has to be transferred &nbsp;to Oracle Database once the form is completed.<br />
<br />
How can I achieve this and can I use SSIS to transfer data ? and how can I trigger the data transfer<br />
<br />
Thanks
</div>
</div>


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

update Oracle Database via SQL 2008

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.