Software Development
Blogs and Discussion
developer.*
Books Articles Blogs Subscribe d.* Gear About Home

SSIS Data Flow derived columns missing downstream--stuck behind Union All Transformation?

Unfortunately, one of the most annoying SSIS bugs did not make the cut for the SQL Server 2005 SP2 bug fix list: 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. Generally, for me anyway, this comes up when you edit an upstream Derived Column Transformation that already has one or more Union All Transformations downstream from it.

The best way I have found to fix this is to delete and re-add each and every Union All Transformation that is downstream from the place where you added the new column(s). Alternately, you can edit each Union All and manually add the missing columns, but since this usually happens to me with multiple columns, I don't prefer this solution most of the time.

Has anyone else found a way to prevent and/or fix this pesky bug? Or have I mis-characterized the problem?

Dan

User login

About our advertising.

Atom Feed

developer.* Blogs also has an Atom feed, located at this url.

Click here for more information about Atom.

A Jolt Award Finalist
Software Creativity 2.0
Foreword by Tom DeMarco

Recent Posters

Based on most recent 60 days, sorted by # of posts and name.

Google
Web developer.*

Who's online

There are currently 0 users and 17 guests online.

Syndicate

Syndicate content
All views expressed by authors, bloggers, and commentors are their own and do not necessarily reflect the views of developer.* or its proprietors.
Click to read the Copyright Notice.

All content copyright ©2000-2005 by the individual specified authors (and where not specified, copyright by Read Media, LLC). Reprint or redistribute only with written permission from the author and/or developer.*.

www.developerdotstar.com