In Java, Jacob calls DTS to import and export data.

In Java, Jacob calls DTS to import and export data.

Keywords: Java Jacob DTS Import and Export

Step 1:
Download Jacob
Http://danadler.com/jacob/jacobBin_17.zip
Decompress the package and put the DLL file in the % java_home %/JRE/bin directory. Put the JAR file in the % java_home %/JRE/lib/EXT directory without configuring environment variables.

Step 2:
Create a data transmission file
Create a data transmission task using the SQL Server Import and Export tool and save it as a storage structure file, for example, D:/temp/DTS/dts_test.dts

Step 3:
Use Java to call the DTs file to execute data import and export Java code

1. PackageDBF;
3. ImportJava. Text. simpledateformat;
4. ImportJava. util. date;
5. ImportCom. Jacob. ActiveX .*;
6. ImportCom.jacb.com .*;
8. Public ClassExportdts {
9. Public VoidExportdbf (){
11. Simpledateformat localtime =NewSimpledateformat ("yyyy-mm-dd hh: mm: SS ");
13. String importfilename = "D:/temp/DBF"; // The Path to store the exported DBF
14. String dtspath = "D:/temp/DTS/dts_test.dts"; // the path of the DTs File
16. Try{
17. System. Out. println ("START:" + localtime. Format (NewDate ()));
19. Activexcomponent APP =NewActivexcomponent ("DTS. package2 ");
22. Dispatch. calln (app, "loadfromstoragefile ",NewVariant [] {NewVariant (dtspath ),NewVariant ("")});
24. // Reset the path
25. Dispatch dtsconns = Dispatch. Get (app, "Connections"). todispatch ();
26. Dispatch dtsconn = Dispatch. calln (dtsconns, "item ",NewVariant [] {NewVariant (2)}). todispatch ();
27. Dispatch. Put (dtsconn, "datasource ",NewString (importfilename ));
29. // Execute
30. Dispatch. calln (app, "execute ",NewVariant [] {});
32. // Obtain the execution result
33. Dispatch dtssteps = Dispatch. Get (app, "Steps"). todispatch ();
34. Dispatch dtsstep = Dispatch. calln (dtssteps, "item ",NewVariant [] {NewVariant (1)}). todispatch ();
35. Variant resultvalue = Dispatch. Get (dtsstep, "executionresult ");
37. If(Resultvalue. toint () = 0 ){
38. System. Out. println ("exported successfully ");
40. }Else{
41. System. Out. println ("Export failed ");
43. }
44. System. Out. println ("end:" + localtime. Format (NewDate ()));
45. }Catch(Exception ex ){
46. Ex. printstacktrace ();
47. }
48. }