Joel,

Have you looked at creating a DTS package in SQL to get the data from Oracle?

>Yes I creat it manually.
>
>I would like to have the Oracle view and then be able to copy directly to SQL.
>
>I guess I need to write a program to create the matching structure in MS SQL?????