hi experts, My sequence goes like this In control flow of BDIS 1) execute sql task :- In this i will execute sp providing input and output parameter to this 2) Transfer sql server object task : In this i am transfering tables from one sql server to another sql server. 3)execute sql task :- In this again i am executing the stored procedure. Problem :- 1) is it ok if i do all the task in control flow. 2) how to i check that step (1) execute successful because i need to perform step (2) only if step(1) executed successfully 3) how do i access the package variable in script task Plz help.