if its just a few records then use query of query to get your subset of results and then insert the results into database B
if this is a regular occurrence and happens often then then you may want to look at creating a DTS script on your SQL server and scheduling that to do the job. On Sat, Mar 10, 2012 at 10:32 PM, IT (Pradeep Viswanathan) < [email protected]> wrote: > > I have couple of records which are filtered from data source x which is > oracle based and require to insert it into datasource y which is MS SQL > server. > > The number of rows, columns is not fixed, however I have the records in a > Query object, what would be the best way to insert get this data into the > other database? > > Thanks in advance. > > > DISCLAIMER: > "This e-mail message including any of its attachments is intended solely > for the addressee(s) and may contain privileged information. If you are not > the addressee or you have received this email message in error, please > notify the sender who will remove your details from its database. You are > not authorized to read, copy, disseminate, distribute or use this e-mail > message or any attachment to it in any manner and must delete the email and > destroy any hard copies of it. > This e-mail message does not contain financial instructions or commitments > of any kind. Any views expressed in this message are those of the > individual sender and do not necessarily reflect the views of Emirates NBD > PJSC, or any other related subsidiaries, entities or persons." > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
