SQLSERVER跨库导入，不能使用旧的OLEDB驱动（自动截断50个字符）。使用最新的MSOLEDBSQL 连接。

select * into #t2 from (

select a.* from (SELECT  cast( CHECKSUM(*) as varchar(50)) as [CheckSum],ZYH,BHID,XM,SFZH,XB,SF,XZZ, CONVERT(varchar,   dbo.fn_ConvertDateTime(RYRQ), 23) as RYRQ,CONVERT(varchar,   dbo.fn_ConvertDateTime(CYRQ), 23)as CYRQ,ZDFLAG,cast(ZZD as varchar(2000)) as ZZD,LCZD,CYQK,SWSJ,SWYY,KSBM,KSMC,ZZYS,ZZYSMC,DATATIME 

FROM  

OPENROWSET(
'MSOLEDBSQL','Server=10.0.0.11;UID=a;PWD=a1122;','select * from v1 where  DATATIME > DATEADD(day,-3, GETDATE()) ' ) 
--使用MSOLEDBSQL驱动 能支持最新的格式，突破旧驱动最多能取50个字符

) a  where a.[CheckSum] not in (select [CheckSum] from  tbl1 )

) b