Good Day All, I have a DTS package that writes the results of a custom query to a delimited text file. My boss wants a back up in case something happens to a specific days text file. My question is, how do I go about writing data to a NEW file every time the script runs.
The client side, it always replaces the current data in their file. But for the "stupid-client" back ups we want each day to have a new file, something like ddmmyyyy.txt. Can I do this with pure SQL? Is there a way to create/use a dynamically created/named file? Any assistance is appreciated greatly! Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
