发表于 2009-1-5 19:48
| 
C#涓娇鐢―TS鏉ュ鍏ユ暟鎹強鐩稿叧闂
鍙戝竷: 2008-6-30 10:12 | 浣滆: admin | 鏌ョ湅: 7娆
鍚慡ql 涓鍏xcel鏁版嵁鏃讹紝浣跨敤MS SQL鐨凞TS鍔熻兘
鍙互寰堟柟渚跨殑瀵煎叆锛屽悓鏃跺紩鐢―ll鏂囦欢锛屽彲浠ュ湪绋嬪簭涓瀵煎叆杩囩▼杩涜鎺у埗銆
鍒涘缓DTS鍖呯殑杩囩▼濡備笅锛
锛戙傚湪锛筹急锛紒涓氱鐞嗗櫒涓紝宸ュ叿鑿滃崟閫夋暟鎹浆鎹㈡湇鍔★紝瀵煎叆鏁版嵁
鎸夌収瀹冪殑鍥惧舰鍖栧悜瀵兼彁绀猴紝鍙互涓姝ユ鍒涘缓涓涓激锛达汲鍖咃紝鍙互閫夋嫨淇濆瓨鍦ㄦ暟鎹簱銆
锛掋傚湪锛筹急锛紒涓氱鐞嗗櫒涓紝宸﹁竟鏍戝舰缁撴瀯涓夋嫨銆鏁版嵁杞寲鏈嶅姟锛屾湰鍦板寘涓
鍙互鏂板缓涓涓寘锛屽悓鏍锋湁鍥惧舰鍖栫殑鐣岄潰寤虹珛鍖咃細鎷栦竴涓狤xcel鏁版嵁婧愶紝鎷栦竴涓猄ql鏁版嵁婧
鐒跺悗鍦ㄤ换鍔￠噷閫 鏁版嵁杞寲浠诲姟锛屽師鏁版嵁閫塃xcel婧愶紝鐩殑閫塖QL锛岀劧鍚庡湪杞寲鐨勮偐澶翠笂閫夊睘鎬
閲岄潰鍙互閰嶇疆杞寲杩囩▼銆傛敞鎰忓甫鏈変富閿殑鏁版嵁琛紝瑕佹妸閫夐」涓 鍚敤鏍囩ず鎻掑叆鍘绘帀
鍦–#閲岃皟鐢ㄨ繃绋嬪涓嬶細
private void RunDTS()
2 {
3 DTS.Package2Class package = new Package2Class();
4 object p = null;
5 package.LoadFromSQLServer("ws-victor-03", null, null, DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,
6 null, null, null, "TestDTS", ref p);
7 package.Connections.Item(1).DataSource = "dts.XLS";
8 package.Execute();
9 }
鐜板湪椤圭洰涓亣鍒伴棶棰橈細
1銆傛彃鍏ユ暟鎹椂闇瑕佹彃鍏ユ椂闂寸瓑Excel鏁版嵁婧愪腑涓嶅瓨鍦ㄧ殑鏁版嵁
2銆侲xcel鏁版嵁婧愪腑鏁版嵁鏈夌殑闇瑕佽浆鍖栵紝鍍忔暟鍊煎舰锛屽鍏ュ悗鍙樻垚浜1銆23131E12绛夊舰寮
3銆傛彃鍏ユ暟鎹椂闇瑕佷粠Sql涓煡璇㈡暟鎹啀鎻掑叆
鐜板湪瑙ｅ喅浜嗙涓鏉″拰绗笁鏉＄殑涓姝ュ垎锛
鍦ㄤ笂杩伴厤缃 鏁版嵁杞寲浠诲姟 鏃讹紝
DTSDestination("ICC") = DTSSource("SIM Number");
DTSDestination("IMSI") = DTSSource("IMSI");
DTSDestination("PIN1") = DTSSource("PIN1");
DTSDestination("PUK1") = DTSSource("PUK1");
DTSDestination("PIN2") = DTSSource("PIN2");
DTSDestination("PUK2") = DTSSource("PUK2");
DTSDestination("MSISDN") = DTSSource("MSISDN");
DTSDestination("Fax") = DTSSource("Fax");
DTSDestination("Data") = DTSSource("Data");
DTSDestination("Barring") = DTSSource("Barring");
DTSDestination("MailFormID") = DTSGlobalVariables("MailFromID").Value;
DTSDestination("ReceiveDate") = new Date().getYear() + "-" + new Date().getMonth() + "-" + new Date().getDate();
return(DTSTransformStat_OK);
鍏朵腑锛孧ailFromID涓哄叏灞鍙橀噺锛屾坊鍔犳柟娉曚负鍖 鑿滃崟 灞炴ч噷闈㈤夋嫨鍏ㄥ眬鍙橀噺锛屽彲鍦–#涓鍏惰繘琛岃祴鍊硷細
foreach(GlobalVariable global in package.GlobalVariables)
{
if (global.Name == "MailFromID") {
package.GlobalVariables.Remove(global.Name);
}
}
package.GlobalVariables.AddGlobalVariable("MailFromID",MailFromID);
鎻掑叆鏃堕棿锛
DTSDestination("ReceiveDate") = new Date().getYear() + "-" + new Date().getMonth() + "-" + new Date().getDate();
鐢╦avascript鎷煎嚭鏉ョ殑 鍝堝搱
鎻掑叆鏁版嵁鏃堕渶瑕佷粠Sql涓煡璇㈡暟鎹啀鎻掑叆锛
鍦ㄥ寘閲屾坊鍔犳柊鐨勪换鍔:
鎵цSql浠诲姟
SELECT AddressList.*
FROM AddressList
WHERE (ID = ?)
鐒跺悗閰嶇疆 杈撳叆鍜岃緭鍑哄弬鏁
杩樺墿涓嬬2鏉℃病鎼炲畾锛屽笇鏈涜繖2澶╄兘鎼炲畾~
http://calmzeal.cnblogs.com/archive/2006/05/28/411499.html
