I have a table on the AS400 that I wish to import into my sql server database. However, I wish to restrict the number of records I import using one of my existing sql server db tables.
Can I create a DTS routine that will import records from the AS400, but will be restricted by the sql server table?
Can this be done & if so what is the syntax, can it be completed via a DTS
Thanks in advance