0

I'm seeing some very strange behaviour when building and running a SSIS Package in Visual Studio:

I have a Script Task that only executes when the containing DataFlow has no Predecessor or I have a break point in my script.

If, the Script Task is simply ignored, all Columns created by the Script Task are NULL.

Has anyone seen this behaviour before?

devlin carnate
  • 8,309
  • 7
  • 48
  • 82
TheJoeIaut
  • 1,522
  • 2
  • 26
  • 59
  • 1
    A screenshot would be helpful here. Also, are you saying the script task is completely skipped over without ever going to yellow in debug? – devlin carnate May 03 '16 at 15:10
  • When you place the breakpoint in your script task, do you step through your code? Is it behaving as intended? – S1r-Lanzelot May 03 '16 at 15:23
  • Questions about code that show no code are rather difficult ti diagnose – billinkc May 03 '16 at 15:36
  • What you are describing does not happen. There is something about what is happening that you are leaving out of the description. – Tab Alleman May 03 '16 at 19:44
  • Do you mean Script Task or Script Component? Script Task exists in the control flow and Script Component exists in data flow. – RichardCL May 05 '16 at 07:52

1 Answers1

0

The problem was, because i coppied some of the Script Tasks they had the same ID.

Recreating the script task fixed the problem for me.

TheJoeIaut
  • 1,522
  • 2
  • 26
  • 59