Re: How to use DTS to create a scenario like Word - Mailmerge kind of functionality

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 14:49:30 +0100

If AWK works, why not keep using AWK. GAWK (GNU AWK) is available as a Win32
build which I have used for pre-processing files for subsequent import into
DTS.

Darren
www.sqldts.com

"Belinda" <belindacur@yahoo.com> wrote in message
news:41af5e48.0406101750.98cad60@posting.google.com...
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:<eKBmYNvTEHA.2408@tk2msftngp13.phx.gbl>...
> > This does not sound like the kind of thing DTS is meant to be doing. It
> > sounds as though you would want to populate a Word Template at known
places
> > with values retrieved from a DTS query. In my opinion this is not for
DTS.
> >
> > You would probably be bettwe sticking to using Word only to do this.
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
>
> Hi Allan
>
> Sorry, for not describing the problem more clearly. This is definitely
> not a typical formatted document template and a data file which I can
> fit into a form letter and a data catalog in Word.
>
> I am currently doing this on UNIX using awk which is a powerful UNIX
> text programming tool and it does a fantastic job. In AWK I haev
> defined variables for values to be replaced and the rest is all
> constant text literals I feed the data file for each record in the
> data file the static template is to be
> substituted and awk reads the data file and substitutes for each
> variable value in the static template. It works well on UNIX the data
> file is quite large I cannot use it on Word and since it repeats every
> week I want to automate it using DTS currently it is automated with a
> awk script on UNIX and runs automatically every week from UNIX
> scheduler cron. I want to move this process to SQL and use DTS to do
> this.
>
> Thanks
> Simon

Relevant Pages

  • Re: How to use DTS to create a scenario like Word - Mailmerge kind of functionality
    ... > This does not sound like the kind of thing DTS is meant to be doing. ... not a typical formatted document template and a data file which I can ... I am currently doing this on UNIX using awk which is a powerful UNIX ...
    (microsoft.public.sqlserver.dts)
  • Shell(AWK) Sheet
    ... column5 and column7 of a data file or output of any ... Syntax of running an awk program ... list all the files whose owner is not "oracle ... Replace first column as "ORACLE" in a data file ...
    (comp.unix.shell)
  • Re: general compression with awk
    ... William James wrote: ... >>my problem is to compress a long text file with recurrent patterns. ... >>experimented with awk but could not find a satisfying solution. ... then on my actual data file. ...
    (comp.lang.awk)
  • Re: AWK or otherway to convert transpose Columns to Rows
    ... > I have a data file with roughly the following format: ... There is an awk newsgroup, ...
    (comp.unix.shell)
  • Re: extracting text in bourne shell
    ... > I want to write a script that exract text from data file i.e ... > % cat data ... > how to prgramme in awk, so if suggesting me the solution in awk please ... Lazlo's Chinese Relativity Axiom: ...
    (comp.unix.shell)