http://www.developerdotstar.com/community/node/730 Comments for "SSIS Data Flow derived columns missing downstream--stuck behind Union All Transformation?" en http://www.developerdotstar.com/community/node/730 <p>Unfortunately, one of the most annoying SSIS bugs did not make the cut for the <a href="http://support.microsoft.com/default.aspx/kb/921896">SQL Server 2005 SP2 bug fix list</a>: namely, when you add additional output columns to a Derived Column Transformation (and maybe other kinds as well) that is upstream from one or more Union All Transformations, the new columns you add get "stuck" behind the Union All transformations--that is, they do not show up as input columns in the Union All, and consequently do not flow past the Union All.</p> <p><a href="http://www.developerdotstar.com/community/node/730">read more</a></p> http://www.developerdotstar.com/community/node/730#comment SSIS (SQL Server Integration Services) Thu, 19 Apr 2007 16:01:43 -0700 Daniel Read 730 at http://www.developerdotstar.com/community