> 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.
I'd second Aaron Rouse's suggestion to use DTS.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
