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 |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2009-07-13 : 12:18:50
|
| Hii am inserting information from a text file to a table using bulk insert..is there a way i can delete the fiel after the export is done via the same stored procedure i am using for insert.thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-13 : 14:24:37
|
| see the belowhttp://www.sqlservercentral.com/articles/Administration/usingxp_cmdshell/1250/ |
 |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2009-07-19 : 20:21:01
|
I don't suppose the term "SOX" means anything here, does it? ;-)I'd move the data to a compressed archive... I wouldn't delete it.--Jeff Moden
"Your lack of planning DOES constitute an emergency on my part... SO PLAN BETTER! ""RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row" |
|
|
|
|
|
|
deleting a file after extracting info from it