Hello All

I have a fixed template in which the only thing that changes is about
8 set of values and rest of the template is constant.

I have another file containing about 5000 records and each of this
record fields I need to substitute in the above fixed template at
regular known positions.

Please advise how I can implement this in DTS.

Thanks
SImon

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


"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

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

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 (AT) yahoo (DOT) com> wrote