Joshua,
I agree that you should use DTS for this for several reasons.
First, the one you mentioned. Second, a DTS package, when properly
written, can be moved from one machine to another to help balance the load
or use distributed resources if your environment changes. Third, you can
specify a different security context for the DTS package, so it doesn't
run under the SQL Server's service account. Fourth, you have the
flexibility of using any FTP package you want or of writing your own with
any of the ActiveX scripting languages installed on the server - VBScript,
JScript, even Perlscript if you install the ActiveState package.
Just a few things to think about.
Eric A. Laney
"We should distrust any enterprise that requires new clothes."
-- Henry David Thoreau
"Tipton Josh (orl1jdt)" <[EMAIL PROTECTED]>
05/30/2003 01:35 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: SP Question
We have a stored procedure that creates and runs ftp. Would it be more
beneficial to let a dts pacakge create the ftp file then run it and parse
out instead of a stored procedure. My argument is that a stored procedure
is using the query processor and a active x dts is using the vbscript
engine. Please help me on this and point out the best.
Thanks,
Joshua Tipton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
