Running DTS from ColdFusion
Posted on Jan 25, 2005
For a project I am working on for my current employer, we had to run a DTS package essentially on-demand to move data aggregated in a number of views from SQL to Access. I knew this could be done, but actually had never needed to build this functionality prior. Fortunately, there are a number of resources available that assisted.Both links I found generally speaking had the same code. They were to:
My code was essentially the PengoWorks version (although like I said they are basically the same). One thing on the PengoWorks version that I did find was that I needed to change the initial code as follows:
@object as int,
@hr as int
AS
DECLARE @output varchar(255)
DECLARE @source varchar(255)
DECLARE @description varchar(255)
Also, for whatever reason (not related to the code above) on our end, the package failed saving across the network. This only became apparent after quite a bit of testing because the error messages from SQL were completely uninformative.
The next step for us is to either move the database across the network using DTS or using CF to make the file accessible for download.
Comments
There are currently no comments for this entry...be the first!