Results 1 to 9 of 9

Thread: Save As dialog

  1. #1
    Join Date
    Nov 2003
    Posts
    8

    Question Unanswered: 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.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Save As dialog

    Yes, on the top right hand corner, click Package and select Save As.

  3. #3
    Join Date
    Nov 2003
    Posts
    8
    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?

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    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

  5. #5
    Join Date
    Nov 2003
    Posts
    8
    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...

  6. #6
    Join Date
    Dec 2002
    Posts
    1,245
    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

  7. #7
    Join Date
    Aug 2003
    Posts
    39
    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.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm rather 1 dimensional.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •