i have created a package for migrating data from source to destination.In control flow,i have used execute sql task for inserting package details and status i.e. In control flow i have used one execute sql task for inserting all details of package and other execute sql task for fetching identity field using max in select qry,after that i have placed data flow task which contains source and destination and based upon success or failure of data flow task,i am updating status of package .For that i am using the retreived identity field value in where clause of a update qry in the final execute sql task.No error coming while executing,but package status is not getting updated as expected.need help ?
Please post the queries you are using, expected and actual results