我用dts将txt文件里的数据导入到SQL Server中,但是老是出错,错误是:
未能进行大容量插入,文件'f:\Users.txt'未找到。
而且还有一个很奇怪的现象:我设置断点发现:在运行coConnection.Password := 'aaa';这一句后,coConnection.Password 的值还是''.怎么回事?大家帮帮忙。下面是代码:var
cPackage : Package2;
coConnection : Connection;
coTask : Task;
coStep : Step;
coCustomTask : BulkInsertTask;
begin
cPackage := CoPackage2.Create; cPackage.FailOnError := True;
coConnection := cPackage.Connections.New('SQLOLEDB');
coStep := cPackage.Steps.New;
coTask := cPackage.Tasks.New('DTSBulkInsertTask');
coCustomTask := coTask.CustomTask as BulkInsertTask; coConnection.ID := 1;
coConnection.ConnectionProperties.Item('Persist Security Info').Value := True;
coConnection.DataSource := edtIPAddr.Text;
coConnection.Catalog := cbDB.Text;
coConnection.UserID := edtUserID.Text;
coConnection.Password := 'aaa';
coConnection.Reusable := true;
coConnection.ConnectImmediate := False;
coConnection.UseTrustedConnection := False; cPackage.Connections.Add(coConnection);
coConnection := nil; coStep.Name := 'GenericPkgStep';
coStep.ExecuteInMainThread := true; coCustomTask.Name := 'GenericPkgTask';
coCustomTask.DataFile := 'F:\Users.txt';
coCustomTask.ConnectionID := 1;
coCustomTask.DestinationTableName := 'dbname..test';
coCustomTask.FieldTerminator := #44;
coCustomTask.RowTerminator := #13#10; coStep.TaskName := coCustomTask.Name; cPackage.Steps.Add(coStep);
cPackage.Tasks.Add(coTask);
cPackage.FailOnError := True; cPackage.Execute(); coConnection := nil;
coCustomTask := nil;
coTask := nil;
coStep := nil;
cPackage.UnInitialize;
cPackage := nil;
end;
未能进行大容量插入,文件'f:\Users.txt'未找到。
而且还有一个很奇怪的现象:我设置断点发现:在运行coConnection.Password := 'aaa';这一句后,coConnection.Password 的值还是''.怎么回事?大家帮帮忙。下面是代码:var
cPackage : Package2;
coConnection : Connection;
coTask : Task;
coStep : Step;
coCustomTask : BulkInsertTask;
begin
cPackage := CoPackage2.Create; cPackage.FailOnError := True;
coConnection := cPackage.Connections.New('SQLOLEDB');
coStep := cPackage.Steps.New;
coTask := cPackage.Tasks.New('DTSBulkInsertTask');
coCustomTask := coTask.CustomTask as BulkInsertTask; coConnection.ID := 1;
coConnection.ConnectionProperties.Item('Persist Security Info').Value := True;
coConnection.DataSource := edtIPAddr.Text;
coConnection.Catalog := cbDB.Text;
coConnection.UserID := edtUserID.Text;
coConnection.Password := 'aaa';
coConnection.Reusable := true;
coConnection.ConnectImmediate := False;
coConnection.UseTrustedConnection := False; cPackage.Connections.Add(coConnection);
coConnection := nil; coStep.Name := 'GenericPkgStep';
coStep.ExecuteInMainThread := true; coCustomTask.Name := 'GenericPkgTask';
coCustomTask.DataFile := 'F:\Users.txt';
coCustomTask.ConnectionID := 1;
coCustomTask.DestinationTableName := 'dbname..test';
coCustomTask.FieldTerminator := #44;
coCustomTask.RowTerminator := #13#10; coStep.TaskName := coCustomTask.Name; cPackage.Steps.Add(coStep);
cPackage.Tasks.Add(coTask);
cPackage.FailOnError := True; cPackage.Execute(); coConnection := nil;
coCustomTask := nil;
coTask := nil;
coStep := nil;
cPackage.UnInitialize;
cPackage := nil;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货