RRD 0 Newbie Poster

In VS2008 Is there a way to run an insert query against 2 different DataSources. I have a source that I would like to select about 10 fields from and insert into a different source.
Example ..
DS1 select 10 fields of data
DS2 Insert those 10 fields of data from DS1