March 8, 2011 at 2:26 pm
You're Welcome.
Take care, Jerid
March 9, 2011 at 7:46 am
One more question: Is there a way to make the drop file conditional? As in, "If exists, drop file". If the file is not already in the folder, I get an error, and the person who uses this file can delete or rename it. It must be one of the expressions. (My SSIS 2008 book arrives tomorrow :-))
March 9, 2011 at 8:14 am
I would try the ForceExecutionResult property of File System Task
March 9, 2011 at 9:38 am
I don't know what happened. now the drop test doesn't work at all. I does drop the file, but turns red and Execution Results says: Task drop test failed. Not very helpful. Especially since it did drop the file. Man, I was in a good place when I left yesterday. Now back to square one. Actually zero since I don't know what's going on.
March 9, 2011 at 9:50 am
If you look in the Error window you can probably get more info. View, Error List
March 9, 2011 at 10:23 am
JeridA (3/9/2011)
If you look in the Error window you can probably get more info. View, Error List
0 Errors, 0 Warnings, 0 Messages. Just in output it says "task failed". Even though it didn't fail since it deleted the file. I feel like I'm being punked.
March 9, 2011 at 10:34 am
I deleted the file task, and re-inserted one. now it works(?).
Back to the task of building an expression to run package even if file does not exist.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply