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 |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2006-10-10 : 17:26:35
|
| can anybody tell how can i copy files from one directory to another using SQL Server DTS. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-10 : 17:47:49
|
| You can do this via an ActiveX script.Tara Kizer |
 |
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2006-10-11 : 00:12:18
|
| Tara...can you post sample code how to do this. I am new to using DTS.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2006-10-11 : 11:09:21
|
| thanks Tara for ur suggestion. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-11 : 13:32:33
|
| I'd actually prefer DTS for this as xp_cmdshell requires sysadmin which should only be used for DBA type purposes.Tara Kizer |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-11 : 22:52:17
|
| if this is scheduled, just create a bat file and schedule it using windows task schedulerI prefer not to depend too much on sql server to isolate processes that don't really need sql server usage--------------------keeping it simple... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-11 : 23:07:05
|
| You can use VB Script, DTS ActiveX, or sp_OA stored procedures to copy the file using the file system object.CODO ERGO SUM |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2006-10-12 : 09:56:37
|
| There is already a DTS Package created and so I was asked to create this process as part of the DTS package. |
|
|
|
|
|
|
copying files