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
}
Printable View
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
}
try www.sqldts.com ;) there's a lot of tutorials there that would walk u through it. :D
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.
Take a look at this example at www.sqldts.com.