In this article, I'll show you how to set up a ColdFusion 5 server and a
Microsoft SQL Server 7.0 that will execute a DTS package through the
ColdFusion server. The main objective is to create a DTS package that will
result in file output that will be delivered to a network UNC path or mapped
drive using a set of stored procedures executed by ColdFusion.
The configuration for this setup will also allow a ColdFusion server to
properly propagate user rights across networked servers and domains for using
shared access.
If you're new to DTS packages, I'll introduce them later. Using DTS packages
helps leverage the power of SQL Server performing many easy tasks without
having to do any ColdFusion coding. For example, you can have a DTS package
query a bunch of tables and out... (more)
This article is a continuation of the how-to guide (Part 1 ran last month)
for setting up a ColdFusion 5 server and a Microsoft SQL Server 7.0 to
execute a DTS package through the ColdFusion server.
The main objective of the guide is to create a DTS package that will result
in file output that will be delivered to a network UNC path or mapped drive
using a set of stored procedures execute... (more)
Bob Snyder
Alf Pilgrim
Per Sjofors
Kirsten Lytsen
Data Recovery Services
Colin Armitage
