you can write a stored procedure for this and then call that stored procedure using Execute Sql task component........
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/