Thanks for posting the solution. I am trying to implement the same solution in my test environment and i am getting error. It states "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly". It throws error on Execute SQL Task. I have followed the same steps as mentioned. I am using SQL Server 2005.
Any help would be appreciated.