Using DTS Packages with ColdFusion: Part 2
By: Tom Muck on Thursday, June 16, 2005
Reader Level: 
Many people use SQL Server to store their data, however SQL Server is much more involved than simply a server that allows storage for data. Data Transformation Services (DTS) is part of SQL Server and allows you to import and export data, manipulate files on the system, use FTP, among other things. Using some of SQL Server's built-in DTS functionality along with ColdFusion gives your web application access to some of this functionality.
Part 1 of this series showed how to export data from SQL Server to a CSV file triggered by a ColdFusion page. This part will show how to upload a CSV file to the server and import it into a new table. It will show how to pass information (a filename) to a DTS package from a ColdFusion page and use it in the package.
Purchase this item
You can purchase this piece of content separately for
$3.00
Want more?
Community MX members get unlimited access to daily articles,
tutorials, extensions and support. The most comprehensive
resource for Macromedia designers and developers today.
Take a tour of what we offer, and discover the benefits
of subscribing.
Already a member?
Simply log in using the form in the top right area of the site.
