This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Calling Data Transformation Services Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Calling Data Transformation Services" Watch "Calling Data Transformation Services" New topic

Calling Data Transformation Services

Raj Kumar
Ranch Hand

Joined: Sep 19, 2005
Posts: 65
in my program i want to call a packaged dts file related to MSSQLServer is it is possible to run it from java and if so how to do that..

thanks in advance
Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 293

You could do this by executing the dtsrun executable that comes with SQL Server.
I agree. Here's the link:
subject: Calling Data Transformation Services
jQuery in Action, 3rd edition