I need to execute the DTS via a Cold Fusion template I know how to due
this but I always run through loops with my DBA about the setup with all
the permissions I need to have setup.
Regards,
-JB
Dave Watts wrote:
> > 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.
>
> 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]
