1 Simple DTS Package Design

I represent a small web design and development firm. I'm a PHP programmer vaguely familiar with MS SQL. I've been trying unsucessfully to design a DTS package. This sql query represents roughly what I'm trying to accomplish. SELECT [mlsnhsql].[idxmls1].*, LTRIM('nnren') AS data_source, LTRIM('1') AS class FROM [mlsnhsql].[idxmls1].*, WHERE [mlsnhsql].[idxmls1].[town] IN (SELECT town FROM [agentmaster].[areas]) My problem is using the DTS designer I can only seem to query one connection at a time. The idxmls1 is a view in a remote database, and areas is a table in my local database containing a list of towns listings need to be dowloaded for. ## Deliverables A few email's or phone calls to get me on the right track. ## Platform Windows 2000 Server, Microsoft SQL Server 2000