This is the process we use here at work. We use DTS to query some views on the oracle server then do some checks within our DTS package and insert the data into the MSSQL server. I think it might run a SP on the MSSQL side as well, but am not 100% certain since been many months since I had to get into any of that.
On 11/21/05, Ken Ferguson <[EMAIL PROTECTED]> wrote: > > You should build a DTS package that runs on a schedule every night. It > will be easy to run those checks and make your inserts... with a DTS > package. > > --Ferg > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224795 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
