Ok if i use DTS. can i set this up...


WHILE NOT EOF
{
1)GET RECORD from input text file
2)run update on table 1 using record
3)run update on table 2 using record
4)run update on table 3 using record
2)run delete on table 4 using record
}