set oralcexe sa password

orapwd file=PWDXE.ora password=iris entries=10

install sql 2008 ee version, need pwer shell in win2008 sp2

down load power shell :http://www.microsoft.com/en-us/download/details.aspx?id=20430

options(errors=1000)

load data

infile "C:\Users\zhchu\Documents\dbo_einfotable.txt"

replace into table EINFOTABLE

fields terminated by ","

(

eid  Integer External,

edate Date "mm/dd/yyyy hh24:mi:ss",

ddate Date "mm/dd/yyyy hh24:mi:ss",

eprice ,

Eprice2 ,

Eprice3 ,

Eprice4 ,

Eprice5 ,

phoneNum,

ename,

mark

)

sqlldr control=D:\SybaseTest\oraclexeload.ctl log=D:\SybaseTest\data_load.log

CREATE TABLE einfotable(

eid  int NOT NULL PRIMARY KEY ,

edate  datetime not null,

ddate  datetime not null,

eprice money not null,

eprice2 money not null,

eprice3 money not null,

eprice4 money not null,

eprice5 money not null,

phoneNum  varchar(20)  not null,

ename  varchar(20)  not null,

mark   varchar(30)  not null

);

insert into einfotable select * from dbo_einfotable;

select COUNT(1) from einfotable;

cd /d c:\windows

Activation context generation failed for "D:\Sybase\ASE-15_0\bin\syconfig.exe". Dependent Assembly Microsoft.VC80.CRT,processorArchitecture="amd64",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.4053" could not be found. Please use sxstrace.exe for detailed diagnosis.

download(vcredist_x64.exe) and install