pivot transformation- Dynamically
How can I add columns dynamically to pivot task output.
March 29th, 2013 2:25am
You cannot add columns dynamically to pivot task or Pivot transformation because the metadata wont be refreshed dynamically. In such cases you need to Create a package dynamically to do all these stuffs.
Below link helps you in creating package programatically.
http://msdn.microsoft.com/en-us/library/ms135946.aspx
Regards
Naveen
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2013 2:46am
Thanks a lot for ur reply
March 29th, 2013 2:52am
How can I add columns dynamically to pivot task output.
If you can use third-party solutions, check the commercial COZYROC
Data Flow Task Plus. It is an extension of the standard Data Flow Task, with support for dynamic metadata. The Pivot Transformation is supported dynamically. No programming skills are required.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2013 1:03pm