Hello All: CFSTOREDPROC ?
Im on an adventure with my SQL 7.0 server and I have a question. What Im attempting to do is run a <CFSTOREDPROC> that generates a large CSV file from an executed DTS package and then output that file to a network share which the DTS will take care of. Next Im going to have my CF server zip that file and serve it to the user. So happy they will be to have their data. 1. While that file is being generated and ColdFusion is zipping up that file is there a way to track the progress and let the user know how long they have to wait? 2. Can I lock the CSV file thats being created in case someone else makes the same requeest tring to over write the file being created by the DTS package? A Special Thanks Today To: Dan Switzers, write up on how to execute a DTS package from a stored procedure talk about cool. You can see his example at: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS Regards, James Blaha ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
