About DTS

[bjr149]

1 question. Say if i create a text file with a record, can i use DTS to do this.

1) Get the file from the mainframe server, or on the actual server
2) loop while not eof in a txt file
3) use record 1 to run a UPDATE query on table 1
4) use record 1 to run a UPDATE query on table 2
5) use record 1 to run a UPDATE query on table 3
6) use record 1 to run a DELETE query on table 4
7) get next record.

I've never used DTS and this is my first "refresh" of a datbase project and i just want to make sure that this would be something that DTS can handle. I imagine it is i'd just rather hear it from someone who is experienced with DTS! thanks

 

[MDXer]

processing record by record is going to cause performance issues. What you can do is import the records of your txt file into a stage table use this table in you update and delete statements by means of a join.



Shoot Me! Shoot Me NOW!!!
- Daffy Duck