Is it possible to run a parameterized DTS?
Say "Run DTS @searchstring"?

And then the DTS would execute SQL: 'select * from table where column like +
'''%' + @searchString +'%'''
to fetch data from remote server.
TIA,
Lefteris.
---------------------------
<?xml version="1.0" ?> 
<CONTACT>
   <NAME>Lefteris Fotopoulos</NAME> 
   <ADDRESS>19,7 L. Markopoulou, A5 Peania 19002</ADDRESS> 
   <E-MAIL>lfot@e...</E-MAIL> 
   <PHONE>+xxx xxxxxxx</PHONE> 
</CONTACT>
---------------------------