Ladies and gentlemen, I posted a question that I export data from SQL to .xls, where is that data of .xls stored?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...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment