SSIS Derived column transformation no Inputs

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

Answers


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.


Need Your Help

Prestashop - Right way to make AJAX request to CategoryController

php json ajax prestashop

I need to make an AJAX call to override the Front Controller. The last way I've tried returns a 403 Status Code, but in the responseText it shows me the correct JSON.

Cross Browser Scrollbar customization

html css browser webkit mozilla

I want to have my scroll bar color changed, I read couple of example online. But they relate to webkit browsers, and that doesn't work in -moz browser. I found a jquery plugin for all browsers call...