delphi下如何调用sqlserver2005的ssis包(dts) rt 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 直接用DELPHI转换就可以了,为什么用DTS?delphi调用dtsfunction execdts(strdts_name: string): boolean; var n: variant; oconnection: variant; ostep,otask,ocustomtask,mopackage: variant; begin mopackage := createoleobject(dts.package2); oconnection := mopackage.connections.new(sqloledb); ostep := mopackage.steps.new; otask := mopackage.tasks.new(dtsexecutepackagetask); ocustomtask := otask.customtask; mopackage.failonerror := true; ocustomtask.packagepassword := user; ocustomtask.filename := strdts_name; ocustomtask.name := execpkgtask; ostep.taskname := ocustomtask.name; ostep.name := execpkgstep; ostep.executeinmainthread := true; mopackage.steps.add(ostep); mopackage.tasks.add(otask); try mopackage.execute; except ocustomtask := n; otask := n; ostep := n; mopackage.uninitialize; execdts := false; exit; end; execdts := true; ocustomtask := n; otask := n; ostep := n; mopackage.uninitialize; end;//要先在import type library里把dtspkg.dll和dtspump.dll安装上 调用方法和调用2000的dts一样是吗? 关于delphi的sos Delphi开发,如何从视频文件(.asf,.wma)提取音频文件,并保存成文件? 如何能在一个事件触发后,让Edit控件里的内容自动全选 有关函数的问题 清除画布上的图画??? ftp客户端 重命名后 卡住 发生错误 treeview的'+'号 如何判断dbmemo为空,谢了 新手请教,我在写隐藏按扭的时候用一个按扭来切换,如何写程序。 Delphi 与Excel如何通讯 fastreport怎麼控制preview的顯示的大小 Delphi中DBGridEh合并行
delphi调用dts
function execdts(strdts_name: string): boolean;
var
n: variant;
oconnection: variant;
ostep,otask,ocustomtask,mopackage: variant;
begin
mopackage := createoleobject(dts.package2);
oconnection := mopackage.connections.new(sqloledb);
ostep := mopackage.steps.new;
otask := mopackage.tasks.new(dtsexecutepackagetask);
ocustomtask := otask.customtask;
mopackage.failonerror := true;
ocustomtask.packagepassword := user;
ocustomtask.filename := strdts_name;
ocustomtask.name := execpkgtask;
ostep.taskname := ocustomtask.name;
ostep.name := execpkgstep;
ostep.executeinmainthread := true;
mopackage.steps.add(ostep);
mopackage.tasks.add(otask);
try
mopackage.execute;
except
ocustomtask := n;
otask := n;
ostep := n;
mopackage.uninitialize;
execdts := false;
exit;
end;
execdts := true;
ocustomtask := n;
otask := n;
ostep := n;
mopackage.uninitialize;
end;
//要先在import type library里把dtspkg.dll和dtspump.dll安装上