Hi,
I have a dts that runs and converts eventlog from NT to SQL tables. I need to schedule this dts such that it will run based on the time that the user specifies. Say 10 min for one server and 20 min for another server. The Server name is already being picked up by the DTS from a table that stores all the servername.
But now the dts runs for all the servers in the servername table at the same time (every 30 min). I have added a column to servername table that stores the run time...(every 10min, 20 min etc.)
How can I pass this value to the dts and run it accordingly at that time.
I have a dts that runs and converts eventlog from NT to SQL tables. I need to schedule this dts such that it will run based on the time that the user specifies. Say 10 min for one server and 20 min for another server. The Server name is already being picked up by the DTS from a table that stores all the servername.
But now the dts runs for all the servers in the servername table at the same time (every 30 min). I have added a column to servername table that stores the run time...(every 10min, 20 min etc.)
How can I pass this value to the dts and run it accordingly at that time.