Example

// force DEWizardX not to use connection from the script file
DEWizardX1.Visible:=false;
DEWizardX1.ParseConnection:=false;

//Stops user from chaging connection parameters through the interface
DEWizardX1.SourceConnectionEnabled:=false;
DEWizardX1.TargetConnectionEnabled:=false;

//Hides SQL before and SQL after  tabs
DEWizardX1.ShowSqlBeforePage:=false;
DEWizardX1.ShowSqlAfterPage:=false;

// specify Target
//DEWizardX1.ImportTargetType:=1; //- dtSqlServer
DEWizardX1.TargetServerName:='Server1';
DEWizardX1.TargetDatabase:='db11';
DEWizardX1.TargetUserName:='user1';
DEWizardX1.TargetPassword:='blah';
DEWizardX1.TargetTable:='mytable';

//Load Script From file

DEWizardX1.LoadFromFile('c:\myscript.txt');

// specify Source
//DEWizardX1.ImportSourceType:=0; //- dstext
DEWizardX1.SourceFile:='c:\1.txt';
DEWizardX1.SourceFileIsDelimited:=true;
DEWizardX1.SourceFileDelimiter:=',';
DEWizardX1.LogFile:='c:\1.log';
DEWizardX1.RejectedRecordsFile:='c:\rej1.log';

DEWizardX1.Execute;

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizardx/example.txt
  • Last modified: 17/09/2018 09:42
  • by admin