Copy, Delete Files, and Transfer via DTS
From: Priska (priska_at_hotpop.com)
Date: 08/26/04
- Next message: Steve Kass: "Re: Clustered index vs. nonclustered index for GUID primary key"
- Previous message: SQLCatz: "Extending Uri's idea..."
- Next in thread: Peter The Spate: "Copy, Delete Files, and Transfer via DTS"
- Reply: Peter The Spate: "Copy, Delete Files, and Transfer via DTS"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 20:03:19 +0700
Hi,
I need to transfer files from another server to my database server (SQL
Server 7).
The job details is:
1. copy the files to backup folder ( d:\ftp\backup_data\ ), the backup
filename added with currentdate and time. I use xp_cmdshell.
2. load the file content to database. I use DTS from text file.
3. delete the source file. (xp_cmdshell).
The problem is xp_cmdshell is denied for accessing a mapping path, so copy
and deletion process will not run. I've try both sql server administrator
level or NT 4 administrator level login, but it still did'nt work.
Is there's anyway to do this?
Thanks in advance
Teguh
- Next message: Steve Kass: "Re: Clustered index vs. nonclustered index for GUID primary key"
- Previous message: SQLCatz: "Extending Uri's idea..."
- Next in thread: Peter The Spate: "Copy, Delete Files, and Transfer via DTS"
- Reply: Peter The Spate: "Copy, Delete Files, and Transfer via DTS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
