Why isn't there an editor for the Pivot Transformation? It is one of the most common transforms I use and the Advanced Editor is a pain in the rear.
Is there a friendly editor available somewhere? =\
Unfortunately there is no custom UI for SSIS Pivot transform,yet (we do have one for unPivot, though), sorry.
SQL BOL should give enough information on how to config this transform, you can also check out Ash's blog http://sqljunkies.com/Article/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk to see whether that helps. If any questions please let us know and we'd like to help.
thanks
wenyang
|||I know how to use it, it's just not very user friendly.|||When do you plan to release a friendly pivot editor?
No comments:
Post a Comment