Hello Phil,

Thank you for the detailed response.

Yesterday, I visited below two links and based on them we've now decided to migrate the package stuff into SQl stored procedure. Once again, thank you for the response.

http://www.jamesserra.com/archive/2011/08/when-to-use-t-sql-or-ssis-for-etl/

https://bennyaustin.wordpress.com/2010/06/26/ssis-pivot-transform-vs-t-sql-pivot/

Thanks,

Ankit