[dba-SQLServer] Data Transformation Packages from SQL Server 2Kto Oracle 9

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



More information about the dba-SQLServer mailing list