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 |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2012-02-21 : 11:35:42
|
| Hi!I have ssis ,before insert to table,ssis take txt file from folder1 and put this txt file to another folder2,I would like delete this file from folder1.....thanks for all |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-21 : 14:24:40
|
| use file system task with delete file as operation------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2012-02-21 : 14:44:44
|
| I used,but no resultat,no errors,but file exist ,when after running I checked... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-21 : 14:47:37
|
| are you sure you've set correct file path as source. is path static or taken from a variable?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2012-02-21 : 14:54:37
|
| I take from variable,i already have file system task ,replace from variable to directory backup,its work good,and I would like delete this file after running ssis ,I run job which run ssis,no errors ,file move to backup folder,but no delete from folder....:( |
|
|
|
|
|
|
|
|
delete file