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