Mutliple databases

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

The J2EE transaction manager controls all enterprise bean transactions except for bean-managed JDBC transactions.The J2EE transaction administrator allows an action bean to amend multiple databases aural a transaction.