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 |
|
lols
Posting Yak Master
174 Posts |
 Posted - 2007-11-28 : 00:59:52
|
| My team is working on a problem. Please help us solve it.I am looping through a set of files and on each loop i process the file and move it to another folder. I am using File System task and variables with destination path and name, to do so . It works fine.Requirement :However now I want that after processing the file, instead of moving it, I create an empty text file at the destination containing the file name. I want to do this with minimum effort. Can anyone suggest me the way.thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-28 : 02:32:29
|
| Create an empty file in the directory with dummy name, just copy it to whatever name you like in the package. |
 |
|
|
lols
Posting Yak Master
174 Posts |
Posted - 2007-11-28 : 02:39:20
|
| Hi,Thanks for replying. How will I create an empty file in the directory? I do not see a "CreateFile" operation in the File System Task editorthanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-28 : 03:29:20
|
| You create it in dos prompt in advance. |
|
|
|
|
|
|
empty text file