declare @ExecSql varchar(500)

set @ExecSql='exec sp_addlinkedserver ''ora'',''oracle'',''msdaora'',''stat'''
exec(@ExecSql)
set @ExecSql='exec sp_addlinkedsrvlogin ''ora'',''false'',''sa'',''bss'',''bss'''
exec(@ExecSql)
IF  EXISTS (SELECT * FROM sysobjects WHERE name='ymtx' and type='u')
DROP TABLE [dbo].[YMTX]
IF  EXISTS (SELECT * FROM sysobjects WHERE name='product_hm' and type='u')
DROP TABLE [dbo].[product_hm]
IF  EXISTS (SELECT * FROM sysobjects WHERE name='product_hm4' and type='u')
DROP TABLE [dbo].[product_hm4]
IF  EXISTS (SELECT * FROM sysobjects WHERE name='hmyys' and type='u')
DROP TABLE [dbo].[hmyys]

set @ExecSql='select * into bss.dbo.YMTX from ora..BSS.YMTX'
exec(@ExecSql)
set @ExecSql='select * into bss.dbo.product_hm from ora..BSS.PRODUCT_HM'
exec(@ExecSql)
set @ExecSql='select * into bss.dbo.product_hm4 from ora..BSS.PRODUCT_HM4'
exec(@ExecSql)
set @ExecSql='select * into bss.dbo.hmyys from ora..BSS.HM_YYS'
exec(@ExecSql)

set @ExecSql='create index access_number on  bss.dbo.product_hm4 (access_number)'
exec(@ExecSql)

set @ExecSql='exec sp_dropserver ''ora'',''droplogins'''
exec(@ExecSql)