Save As dialog

Hi,
Is there any way to prompt as Save As dialog in a DTS package that allows the user to pick the path and filename of the document to be exported?
Thanks.Yes, on the top right hand corner, click Package and select Save As.|||hehe.. maybe i wasn't too clear on what i'm trying to do.

I'm calling this package from a web page. What I want this to do is to pop-up a save dialog so that the user can choose the path and filename of the exported file to be saved on their computer when the package runs.

But this brings up another question... technically, the web server would be calling this package so it would save it on the server's drive rather than the client. Is there any way to tell it to save to the client or would I have to save it temporarily first on the server than send that to the client?|||We do this on our internet site. We use ADO, save the data to the ADO stream as XML, transform it using an XSL (to format the data into comma-delimited) and then write the results into the Response object.

Since the DTS package is being run in the context of the web server, I would think that you are going to have to save the file first, then http it to the user's client.

hmscott|||well we've got it figured out that we're going to create a temp file on the server, have the page link directly to that file which will prompt the user to save since it's an excel file... then after the client save/cancels, delete the file.

now my problem is.. how do i call a package using java? i've seen NO code to do this...|||Please don't take this the wrong way, but usually I find that when a problem like this starts leading to more and greater complexity, then there is often times a simpler, more elegant, better performing (and easier to support) solution.

I dunno the specifics of your situation and I am not trying to be judgmental, but perhaps by retracing your steps back up the ladder, you may find an easier way down...

hmscott|||Originally posted by hmscott
Please don't take this the wrong way, but usually I find that when a problem like this starts leading to more and greater complexity, then there is often times a simpler, more elegant, better performing (and easier to support) solution.

I dunno the specifics of your situation and I am not trying to be judgmental, but perhaps by retracing your steps back up the ladder, you may find an easier way down...

hmscott

Yea, what he said. Sometimes DTS can be more work that it is worth. It looks like you are trying to figure file delivery issue. Your idea of creating a temp file may work.

To execute the DTS package from jsp, I would suggest looking up how to execute the package using DTSRUN and the command shell in java.|||sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...
sproc...bcp...unc...format file...t-sql...|||I'm rather 1 dimensional....