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
# 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