• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1390
  • Last Modified:

Using Java to run DTS

hi,

i've a  DTS package in a  .DTS file format

Is it possible to initiate a DTS package remotely from java, maybe using JDBC?  Any examples would be greatly appreciated.
0
chee_torr
Asked:
chee_torr
1 Solution
 
danblakeCommented:
You may not like this, but you would have to write the following
1) A SQL Server Job to execute the DTS File from .DTS File format using dtsrun (see BOL)
2) A Java call to the database server to run a sp_startjob @jobname on the sql-server to start the sql-job.

I do not think that you can directly call the DTS packages directly from within JDBC.

Or alternativly initiate a call to the dtsrun utility within java (a simple command prompt external execution).
DTSRun:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/dts_overview.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp

Java call:
http://www.experts-exchange.com/Programming/Programming_Languages/Java/Q_21064042.html
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now