How to connect oracle with SQL 2000

Good evening,

I would like to ask help from professionals, I have oracle database as old system and SQL server 2000 as new system ,these databses for accounting department so we would make oracle as publisher server and SQL as subscriber which we be sure the database in the two system is synochornize. but the main problem I can't make oracle as publisher because when I go to SQL server2000, replication, no option for non sql server.

so I would like to help asap.

thank in advance....have you looked at scheduling a DTS package to import data from Oracle to SQL Server (rather then replication)?|||Making Oracle, or any other non-SQL Server database, publisher is not possible with SQL Server replication. It's only possible to make other platforms subscribers (and even that is a bit tricky).

To achive your goal by replication you will have to use Oracles replication solution or a third party replication tool.

How to choose one of two success-paths?

I have an ActiveX Script Task in SQL Server 2000. It chooses one of two
possible success-paths depending on if a file exist or not. (Part of the old ActiveX Script for choosing next step is below)

I need to rewrite this for a Script Task in SQL Server 2005 but it seems like it
doesn't have this functionality and objects.

Does anyone know how to write the code for choosing the next step in a
Script Task or knows another way to solve my problem?

The package is not suppose to fail if the file is missing, it's must succeed and that's why I need two success-paths.

Regards,
Sara

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main ()

Dim pkg
Dim stpContinuePkg
Dim stpExit

SET pkg = DTSGlobalVariables.Parent

SET stpContinuePkg = pkg.Steps("DTSStep_DTSActiveScriptTask_4")
SET stpExit = pkg.Steps("DTSStep_DTSActiveScriptTask_21")

If ...... Then
Main = DTSStepScriptResult_ExecuteTask
stpContinuePkg.DisableStep = False
stpExit.DisableStep = True
Else
.......
End If

Main = DTSTaskExecResult_Success

End Function

What you are talking about is conditional execution. You're right that you have to write script to do this in DTS but it is much easier in SSIS because you can put conditions on the precedence constraints.

All explained here: http://www.sqlis.com/default.aspx?306

-Jamie

|||

Thanks a lot for your answer!

Regards,
Sara