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 |
|
dirwin26
Yak Posting Veteran
81 Posts |
 Posted - 2006-10-19 : 08:51:27
|
| I've created a local DTS package which runs fine when I execute locally. I'm trying to build a SP to execute the package with this:exec master..xp_cmdshell 'DTSRUN.exe /S "server" /U "sa" /P "pw" /N "package"' But i get this error. Error string: The Microsoft Jet database engine cannot open the file '\\XX\YYYYY\est\file.xls'. It is already opened exclusively by another user, or you need permission to view its data. I've set everything to run on the system account (sql server and sql server agent) and I have full permission to access the file in question and no one is in the file.thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-19 : 09:25:35
|
| Does the sql server system account have permission on that file/folder?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
dirwin26
Yak Posting Veteran
81 Posts |
Posted - 2006-10-19 : 10:16:00
|
| I would assume yes b/c I can run the package directly within DTS. How can I check that?Thanks |
|
|
|
|
|
|
Cannot open file