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