I have a file in MySQL format that I bring down from a web site daily. I've
manually scrubbed this file to use it in SQL. I've loaded all db objects and
now am only interested in the INSERT statements. Is there a way using DTS to
stop the manually process of scrubbing the data so its usable in SQL, and
configure DTS to do the process instead?

Hello SQLcat,

What kind of scrubbing? Sure DTS can do scrubbing out of the box and with
a little ingenuity can do a lot more. SSIS is much much better though.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Well, there are CREATE TABLE statements that come over with each script. I
need to omit those. I manually mark the INSERT statements and run them.
There are some syntax errors that need to be fixed as well.

"Allan Mitchell" wrote:

Hello SQLcat,

Well yes you could take care of things in DTS using VBScript. it may be
painful because VBScript often is. My temptation would be though to have
a grown up language do the file scrubbing and dump the files to a location
where you can pick them up.

if this was SSIS then the story would be very different.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

sorry, its SQL 2000 around here for now. Yes, I'm working with someone else
in utilizing VBScript which I'll incorporate into the ActiveX Script
component in DTS. Maybe once I'm past that step we can continue with DTS
discussions.

"Allan Mitchell" wrote:

Hello SQLcat,

Sure we can. always glad to talk DTS and SSIS

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com