Running DTS package through JSP application

Hi

I am working on a web application using JSP. I need to run a dts package(SQL Server 2000 ) on each clicking of a button and also pop up a donload window for the file generated by this dts.

The dts package is saved in "C:\Classification" folder on server and the file generated by this dts is also saved in this location.

I tried a lot to get some help on this regard but could not get any . So any kind of suggestion or code or any stuffs may help me a lot.

Thank u

[503 byte] By [invincibleBoona] at [2007-11-26 19:56:24]
# 1

hello,

you just want to serve a file from a servlet?

set the good mime type of the response

then write your file binary to the output stream of the response

//in your servlet

response.setContentType("<mime type of dts >");

OutputStram out=response.getOutputStream();

InputStream in = new FileInputStream("C:\\Classification\\<yourfile>");

IOUtils.copy(in, out); //you'll find this one in the commons-io package, on the apache website

in.close();

out.close();

for the "pop up" thing... it's a client side (html/javascript) matter

alban.maillerea at 2007-7-9 22:50:23 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...