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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-11-03 : 07:41:30
|
| how can i send files by ftp?i have files with *.xls,*.exe |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-11-03 : 11:45:40
|
| you don't send it you just create an Ftp reference point and make sure you have the rights issues worked out, that whatever security context the SSIS package it running has rights to post files to the ftp. add an ftp task to your control flow.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-11-04 : 04:44:37
|
| ok,i have another problem:how can i delete all remote files in the FTP? (i want to use with ftp task)i deleted one file, but how can i delete 2 files (aa.DOC,bb.xls)did i need 2 ftp tasks?thanks |
|
|
|
Rajeshrrk
Starting Member
3 Posts |
Posted - 2009-11-04 : 08:56:16
|
remove aa.Doc bb.xls should do it quote:
Originally posted by inbs
ok,i have another problem:how can i delete all remote files in the FTP? (i want to use with ftp task)i deleted one file, but how can i delete 2 files (aa.DOC,bb.xls)did i need 2 ftp tasks?thanks
|
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-11-04 : 09:38:47
|
| do you mean that i need two ftp tasks? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-11-04 : 11:05:04
|
| maybe a for each loop container might be best in that scenario<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
FTP