Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    South Africa

    Unanswered: DTS Excel Database

    Ladies and gentlemen, I posted a question that I export data from SQL to .xls, where is that data of .xls stored?

  2. #2
    Join Date
    Nov 2002
    ummmmmmm..where you tell it....

    You also have to remeber this...if you run the package manually, it will run under the contex of your login (meaning your mappings)

    If it's scheduled, it will run under then context of the system account (or how the server see's itself..)

    So if you map the excel to a c:\temp, and you run it, the file will be on your c drive..

    If you schedule a job (or start a job) it wil;l place it on the servers c drive...

    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