I have a SQL Server Query file which has a bunch of Insert statements. I need to run this in SQL Server 2000 Database on a daily basis. What is the easiest way to automate this. Is it a way to do it in DTS package?
If these really are a group of INSERT statements with values supplied, you can just put them in a TSQL step in a scheduled job without using DTS. You could also put the statements in a stored procedure and execute the procedure in a job step.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply