Identically Named Variables and Different Scopes
In this case, I think you need to use Script Task. Unfortunately, I'm not familiar enough with using SSIS's Script Task. Maybe this page is helpful:
http://whiteknighttechnology.com/cs/blogs/brian_knight/archive/2005/12/30/57.aspx
Please mark as answer if this helps. Thank you.
http://thebipalace.wordpress.com
February 11th, 2011 6:41am