Two Laptop Bag
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
It's not a secret anymore!