I'm trying to pull records from a informix database on a unix box into a temp table in sql server 2005. Is there a way to create a dataset and dump all the records without going through them one at a time and doing inserts?

Any help would be appreciated.

Thanks