SSIS
-
I explored SSIS, used a Script Task and a File System Task Items, code a little in C# in Script Task(as I have said before, I also into C# learning) and modify file destination and file source in File Task (as I'm going to copy a file from one destination to another) then try to run it. This is the output:
Task failed: File System Task
SSIS package "FileCopy.dtsx" finished: Success.How can it say that it is successfully completed if File System Task failed to do its job? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
I explored SSIS, used a Script Task and a File System Task Items, code a little in C# in Script Task(as I have said before, I also into C# learning) and modify file destination and file source in File Task (as I'm going to copy a file from one destination to another) then try to run it. This is the output:
Task failed: File System Task
SSIS package "FileCopy.dtsx" finished: Success.How can it say that it is successfully completed if File System Task failed to do its job? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
Because it was destined to fail: and it didn't reach it's destiny! Hence it's success was it's own failure, but at least it succeeded in reporting it's failure to fail successfully.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
-
Because it was destined to fail: and it didn't reach it's destiny! Hence it's success was it's own failure, but at least it succeeded in reporting it's failure to fail successfully.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
Brilliant!
"apparently people get really pissed off when you stop speaking in the middle of a "
-
Because it was destined to fail: and it didn't reach it's destiny! Hence it's success was it's own failure, but at least it succeeded in reporting it's failure to fail successfully.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
Now my brain take its day off. Tsk. Its not working! :sigh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
Now my brain take its day off. Tsk. Its not working! :sigh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
Well, it is Poets day! :laugh:
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
-
I explored SSIS, used a Script Task and a File System Task Items, code a little in C# in Script Task(as I have said before, I also into C# learning) and modify file destination and file source in File Task (as I'm going to copy a file from one destination to another) then try to run it. This is the output:
Task failed: File System Task
SSIS package "FileCopy.dtsx" finished: Success.How can it say that it is successfully completed if File System Task failed to do its job? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
Karen Mitchelle wrote:
How can it say that it is successfully completed if File System Task failed to do its job?
If I remember correctly I gave up on SSIS and wrote a windows service because of that very issue. Far as I could tell it was impossible to get one of the tasks that I using to actually return an error to upper level. So I couldn't get it to report a failure.
-
I explored SSIS, used a Script Task and a File System Task Items, code a little in C# in Script Task(as I have said before, I also into C# learning) and modify file destination and file source in File Task (as I'm going to copy a file from one destination to another) then try to run it. This is the output:
Task failed: File System Task
SSIS package "FileCopy.dtsx" finished: Success.How can it say that it is successfully completed if File System Task failed to do its job? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
l It Successfully ReportEd that It Didn't Copy The File. I Have Been Wrestling With Ssis For The Last Two Years
You'll never get very far if all you do is follow instructions.
