Re: Is DTS an appropriate tool?

#1

Sure DTS could do this but if the rules are complex then I would probably
end up using VBScript inside a package.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"William Pierce" <William Pierce (AT) discussions (DOT) microsoft.com> wrote

Quote:

Folks:

I am trying to write an app that will take a CSV input file, I, and
transform it according to some rules, R, and produce a new CSV file. As
new clients come in and new inputs are given, we have to manually
generate
the rules to produce the outputs.

What I want to do is this: Write an app that at run time can read the
transformation rules (which can be provided in some text file) and apply
it
to the appropriate input file and an output is produced. This way the
program itself does not need to change.

The transformation rules may be complex and not necessarily simple.
Currently, the application is written in VBA for Excel and we modify the
relevant routine for each new client we get.

I was wondering whether it would be feasible to do this in DTS or whether
I
should pursue a different scripting strategy.

Thanks,

William

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Is DTS an appropriate tool?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Is DTS an appropriate tool? - 08-16-2004 , 02:37 PM