Doug, Wow, sounds good but how and where do I do this. The CSV file is created from the DTS package, I just call it from the stored PROC. Do you have an example for what I need to modify?
Regards, James Blaha [EMAIL PROTECTED] wrote: >In this case where James is creating a CSV on the fly, he could name the file >uniquely. I usually concatenate a file name with CreatUUID(). This way the file >name is unique to the request, well as unique as the createUUID() function is. > >Doug > > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >>Sent: Thursday, March 13, 2003 4:04 PM >>To: CF-Talk >>Subject: Re: CFSTOREDPROC ? >> >> >>2) It is recommended that you always use <cflock> with >><cffile>. You would do an exclusive lock for >>writing/deleting/copying. You would do a readonly lock for reading. >> >>I'm not sure about CFMX though. I'm fairly certain that the >>java.io classes aren't threadsafe. >> >> >> >>----- Original Message ----- >>From: James Blaha <[EMAIL PROTECTED]> >>Date: Thursday, March 13, 2003 1:26 pm >>Subject: CFSTOREDPROC ? >> >> >> >>>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
