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.