Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 CallDTS from Java

Author  Topic 

yyogesh
Starting Member

5 Posts

Posted - 2014-07-21 : 02:56:32
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
   

- Advertisement -