and it is a DTS package that connects to the Oracle 9i server and
pulls data out of views and places that data into tables on the SQL
Server then manipulates that data into the final tables that their
application accesses.
On Tue, 10 Aug 2004 10:51:50 -0400, James Blaha <[EMAIL PROTECTED]> wrote:
> CFers,
>
> I'm need some advice. I have a few tables in Oracle 9i that I need to
> get into SQL Server 7 daily and when needed, the basic function of the
> process is get the data from Oracle then perform some joins followed by
> creating a new table in SQL Server with the results each time this job
> is run.
>
> What's the best way to do this? Right now I have a CFMX server with a
> JDBC connection to Oracle then I CFQUERY my way through this task using
> a CFM template. I was thinking if I could use a SQL Server SPROC this
> might be a better method.
>
> Does anyone out here do anything like this? By what I've been
> researching using a SQL Server "Linked Server" may be the option I'm
> looking for.
>
> Regards,
> -JB
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
