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 |
|
debimishra
Starting Member
2 Posts |
 Posted - 2007-10-23 : 03:25:18
|
| Hi All,I am working on a server movement work.The application is moving from sql server 2000/windows 2000 to sql server2005/windows 2003.I have a DTS package including some stored procedures which operates on the sql server.I am using xp_cmdshell for copying and deleting excel files.And I am using microsoft.jet.4.0 to fill the excel file with data from a temp table.The dts goes fine but it is not copying the excel template from one location to other.Again while deleting the 2 months old file i got an error saying cannot delete the files.It was running correctly in sqlserver 2000.I have enabled the xp_cmdshell feature in the configuration.Please help me and suggest me.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-23 : 06:12:21
|
Have you set the proper security permissions on the windows file system?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-23 : 22:56:21
|
| Sql service startup account's permission specificly. |
|
|
|
debimishra
Starting Member
2 Posts |
Posted - 2007-10-24 : 00:36:20
|
| Thanks for the reply...Yes, the folder where the file would be created or deleted is given full permission to all.rmiao, can you please let me know how to check Sql service startup account's permission??Thanks Again |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-24 : 22:39:05
|
| Find out sql service startup account in sql server configuration manager, then check it's permission on that folder. |
|
|
|
|
|
|
Operating on .xls file