You can use SQL Server DTS to write the file and you can also execute the DTS using "xp_cmdshell" extended stored procedure.
Joe >From: S. Isaac Dealey <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: OT : SQL Server Bulk Copy Date: Thu, 19 Sep 2002 14:59:58 -0400 > >Can anyone on the list who's familiar with BCP for SQL Server 2000 point me >in the direction of some documentation or an article which explains how to >write data to a file from within query analyzer? We have a project which >will require writing data to a file from a scheduled DTS task on the sql >server machine, which is separate from the cf server, so I can't use ><cfexecute> to access BCP.exe via a command line. > >S. Isaac Dealey >Certified Advanced ColdFusion 5 Developer > >New Epoch >www.turnkey.to >954-776-0046 > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
