Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-25 : 09:47:23
|
| Matthew writes "I have a couple packages that export records from SQL server and writes to a flat file. Whenever the packages are scheduled they won't write the file to to the mapped network drive (mapped on the SQL server box itself) and the job fails. When the package is manually executed it writes correctly to the mapped network drive or to it's own local drive. I am logging into the SQL server with the admin account (or so I think) so I'm assuming that that account is able to run SQL Agents/Schedulers. Help !!MS SQL 2000 on MS 2000 Server" |
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2002-07-25 : 09:57:27
|
| Hi,Please take a look at this article. Looks like the SQL server box might not have sufficient crendentials for the other box.When you execute it manually the DTS package runs with the Local machine's credentials. When you schedule it, the package uses the credentials of the SQL Server box.http://support.microsoft.com/default.aspx?scid=kb;en-us;q269074 ByeRamdasRamdas NarayananSQL Server DBA |
 |
|
|
|
|
|
Scheduled Export Package wont write to Mapped Net Drive