Arthur Fuller
artful at rogers.com
Tue Dec 16 23:43:00 CST 2003
I looked through his code and while I did not find his app up to my needs, I did find enough code to easily change it to suit my requirements. He did a very nice job, IMO. Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Monday, December 15, 2003 11:19 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Data Transformation Packages from SQL Server 2Kto Oracle 9 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com