1
votes

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. ThanImageks.

1

1 Answers

1
votes

This doesn't make sense. Even if it was possible, the "derived column" transformation applies to every row on your source; so in your case, you wouldn't have any rows with your new column, so you wouldn't be able to use it anyway.