I dont know if this is possible. In SSIS Derived column transformation, can you run the package without any inputs?
For example, you have a data flow task and within that you just have your Derived column transformation act as your source. The reason being, you can access the system variables in this way without writing a script for it. Below is the screenshot that I am trying to achieve. The package does not fail, but I cant see anything on the data viewer (it doesnt even get executed). Any help is appreciated. Than
ks.