3 Replies - 332 Views - Last Post: 28 July 2014 - 05:47 AM Rate Topic: -----

#1 yyogesh  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 21-July 14

Call DTS From Java

Posted 21 July 2014 - 03:16 AM

Please help us whether we can call DTS directly from Java.

Solution which we got as below:-

1. Create dts

2. Create job in which we have to call dts

3. Call job from stored procedure

It pretty lengthy process and we are not sure how error handling can be done in this scenario.

Request all to help with proper guidance.

Regards,
Yogesh
Is This A Good Question/Topic? 0
  • +

Replies To: Call DTS From Java

#2 g00se  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 2725
  • View blog
  • Posts: 11,457
  • Joined: 20-September 08

Re: Call DTS From Java

Posted 21 July 2014 - 06:58 AM

Quote

DTS


Defense Travel System?
Was This Post Helpful? 0
  • +
  • -

#3 yyogesh  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 21-July 14

Re: Call DTS From Java

Posted 28 July 2014 - 05:15 AM

Data Transformation Services (DTS) in SQL Server 2000
Was This Post Helpful? 0
  • +
  • -

#4 g00se  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 2725
  • View blog
  • Posts: 11,457
  • Joined: 20-September 08

Re: Call DTS From Java

Posted 28 July 2014 - 05:47 AM

DTS Run Utility can be run with Runtime.exec

http://technojeeves..../13-runtimeexec
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1