I have a table with 40,000 keys on SQL Server.
In a SQL Task I can create a recordset from that table as an output parameter in a global variable.
I have ODBC access to an Informix DB in DTS.
I don't know how to join the Informix Table with the SQL table.
I don't know how to make the Informix a Linked Server.
So, I would like to join the recordset Global variable with the Informix table. How to do this?

An alternative is to loop thru the recordset as described in the Darren Green article http://www.sqldts.com/?298. For every row, we can do a select from Informix. That's 40,000 Selects! I am afraid that will run until next year.

Any help will be appreciated.


---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

I would try to create the linked server to Informix from SQL Server (Details in Books Online) OR I would transfer the rows from one
of the datasources to the other. This means all the rows are in one place and you can issue a much simpler statement from there.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote