The way I usually go about it is to get the data you need through a stored proc and store it in a global temp table. From the stored proc you can execute your DTS package using the dtsrun command which grabs the data from the temp table and puts it into your file.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of KNOTT, Brian > Sent: Thursday, 18 March 2004 11:06 AM > To: CFAussie Mailing List > Subject: [cfaussie] RE: Padding text strings > > Thanks Guys. > > Any thoughts on fixed file exporting. Should I be using > Stored procedures or DTS to do this. Any examples out there (MS SQL). > > Brian > > > -----Original Message----- > > From: Matthew Walker [SMTP:[EMAIL PROTECTED] > > Sent: Thursday, 18 March 2004 9:59 > > To: CFAussie Mailing List > > Subject: [cfaussie] RE: Padding text strings > > > > Or I think lJustify() > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:bounce-cfaussie- [EMAIL PROTECTED] On Behalf Of > > > Lindsay Evans > > > Sent: Thursday, 18 March 2004 11:57 a.m. > > > To: CFAussie Mailing List > > > Subject: [cfaussie] RE: Padding text strings > > > > > > [EMAIL PROTECTED] wrote: > > > > Presently I'm doing a len on the data and then using > cfloop to add > > > > X spaces. > > > > Is there a better method. > > > > > > Use RepeatString() instead of <cfloop> > > > > > > -- > > > Lindsay Evans. > > > Developer, > > > Red Square Productions. > > > > > > [p] 8596.4000 > > > [f] 8596.4001 > > > [w] www.redsquare.com.au > > > > > > > > > --- > > > You are currently subscribed to cfaussie as: > > > [EMAIL PROTECTED] To unsubscribe send a blank email to > > > leave-cfaussie- [EMAIL PROTECTED] > > > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > > http://www.mxdu.com/ + 24-25 February, 2004 > > > > > > > > > > --- > > You are currently subscribed to cfaussie as: > > [EMAIL PROTECTED] To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > http://www.mxdu.com/ + 24-25 February, 2004 > > > -------------------------------------------------------------- > --------------------- > > The contents of this message are the views of the Author and > do not necessarily reflect the views of SUNCORP METWAY LTD > ABN 66 010 831 722. > > The content of this e-mail, including attachments is a > confidential communication between the Suncorp Metway Group > and the intended addressee. Any unauthorised use of the > contents is expressly prohibited. If you have received this > e-mail in error please contact the sender immediately and > then delete the message and any attachment(s). > > http://www.suncorp.com.au > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank > email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
