Solved

Using Java to run DTS

Posted on 2004-08-23
3
1,314 Views
Last Modified: 2013-11-30
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
Comment
Question by:chee_torr
3 Comments
 
LVL 13

Accepted Solution

by:
danblake earned 500 total points
ID: 11872477
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now