Is there a way to use a DTS package to transfer data from one server to another, where the records to be transferred depend on a variable that has to be passed to the DTS package?
The query is very simple:
SELECT field1, field2, field3 FROM WHERE field4 = @lParameter
The value of the parameter @lParameter varies and I would like to pass it to the DTS package.
