It's simple but I can't make it work, and I read in so many places a lot of solutions but nothing worked for me. How can I accomplished this?
Note
I put a break point in my code and ran the entire package, but it still did not work.
5 Answers
For SSIS 2008 where you can only debug the Script Task not the Script Component as already noted by Joost, I've had success using
Trace.Writeline("SSIS .....");
Then I'm capturing this output with good ol Dbgview.exe from https://docs.microsoft.com/en-us/sysinternals/downloads/debugview. I set Edit->Filter->Include SSIS* and then if you're going to leave this on your desktop set the Debug View History Depth to 99999 or it'll fill up the log with no size limit!
Related