?
Solved

Using Java to run DTS

Posted on 2004-08-23
3
Medium Priority
?
1,364 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Accepted Solution

by:
danblake earned 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

752 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