DTS编程，谁比较有经验？
DTS编程，谁比较有经验？大家交流一下^_^！

[解决办法]
就的例子:
不能...偶就意思意思了,方法很多

{sql connection} =======(transfor task)====> {sql connection}

在transfor task的source中,sql command,然後直接下sql,

select id,case [血型] when '0 ' then 'o ' else [血型] end as [血型]
from A.dbo.血型表

--------------------------------------
或者拖2connection分接A & B
然後拖一Execute SQL Task,直接下command,
insert into B.dbo.血型表(id,[血型])
select id,case [血型] when '0 ' then 'o ' else [血型] end as [血型]
from A.dbo.血型表