Using DTS In SQL Server

[bjr149]

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
}

[oceanebelle]

try www.sqldts.com there's a lot of tutorials there that would walk u through it.

[vb_dba]

You can create and ActiveX script task that allows you to use VBScript to do just what you ask. If you are familiar w/ writing ASP web pages, it is very similar.

You could also upload your text file into a temporary table and then use T-SQL to update/delete from your tables. That may be quicker than trying to process each individual record in the file one at a time.

[kaffenils]

Take a look at this example at www.sqldts.com.