MartyConnelly
martyconnelly at shaw.ca
Tue Dec 16 01:18:38 CST 2003
I don't know if this would be any help but the VB source code for a large DMO-SQL program equivalent to Enterprise Manger is available here. http://www.asql.biz/DbaMgr.shtm http://www.asql.biz/DbaMgr/DownLoad.shtm If not you could e-mail Andrea Montanari at andrea.sql at virgilio.it and he might be able to point you in the right direction Microsoft finally made him an MVP last month. Stoker, Kenneth E wrote: >Everyone, > >Has anyone had any experience with this? I have a coworker who came to >me asking if I could help him. I don't have any experience working with >Oracle within DTS. > >We are trying to first validate what data is in the Oracle 9 database >and make inserts from the SQL Server database of what is missing. > >Does anyone also have any good book recommendations for programming DTS >Packages? > >Thanks everyone. Always a help. > >Ken Stoker >Technology Commercialization >Information Systems Administrator >PH: (509) 375-3758 >FAX: (509) 375-6731 >E-mail: Kenneth.Stoker at pnl.gov > > > -- Marty Connelly Victoria, B.C. Canada