IS IT Possbile to Invoke DATASTAGE (oracle Package) Job in Dot Net .

Hi ,

Anyone help me. Now we can do Invoke SSIS Package into ASp.NET.

Vice versa

Is there Possbile to invoke Datastage (oracle Job) into ASp.net? . Is already created in Oracle DataStage Server. it call or access through Dot net. Is it possble? Please any one help me.

Thanks & Regards,

Jeyakumar.M

chennai

What are the interfaces to run a DATASTAGE package. Web service, COM, OLEDB. Any of these would enable you to start the package from SSIS. The script component can do anything you can do in .Net

Is it possbile to define Database server and web server on different machine (Not same phy

Hi All,

Is it possbile to define connection string for web and database server which is running on different machine. Note( Not same LAN).

E.g (My Web Server is in London and Database server in Sydney).

Please can any one help me.??

Thanks in advance...

Dj

They dont need to be on the same LAN, but you'll still need a viable WAN link.

To connect you could use the remote servers IP address with sql credentials.

data source=192.x.x.x;initial catalog=yourDatabase;user id=yourUsername;password=yourPassword;