"tristant" <krislioe@cbn.net.id> wrote in message
news:%23fCLANQXEHA.716@TK2MSFTNGP11.phx.gbl...
> Hi All,
>
> I want to transfer data from SqlServer2000 tables into Oracle 9i.
> I use Transform Data Task, when I specify the destination table, table
does
> not exist yet, and it dts offers to 'Create Destination Table', when I
press
> Create, the script is :
> CREATE TABLE "Product_Temp" (
> "KDPROD" CHAR (16) NOT NULL,
> "KDDIVI" CHAR (2) NOT NULL...
>
> I Should NOT run this script in Oracle since it will make my table name
and
> Column name 'CASE SENSITIVE', means "Product_Temp" will NOT equal
> "PRODUCT_TEMP".
>
> Is there anyway/setting, to make the script generated by DTS Not Include
any
> "Double Quote", so the script should be :
> CREATE TABLE Product_Temp (
> KDPROD CHAR (16) NOT NULL,
> KDDIVI CHAR (2) NOT NULL...
>
> Is this possible ? Or I have to delete the "" manually ?
>
> Thank you for your help,
> Trist
>
>