Hi, I have a package say A which is having a select statement (say some Codes), the result selected from this package by select query needs to send to other package say B now on the basis of these codes we need to execute a insert code and then result 0 or 1 which we need to send back to the package A. How we can achieve that ? Thanks in advance Amit

The other package can simply read the data from a file or a database table. You can also use parent - child package setup. Arthur My Blog

Hi Arthur No, we need to pass in the same way data from A to B and then 0 or 1 from B to A. Is it possible in SSIS. Thanks, Amit

So if you need a two way communication then as per your other thread I suggested you simply use a table or file to exchange data.Arthur My Blog

Hi Arthur, Is it possible in SSIS packages without using SQL Server database tables or Files? Thanks, Amit

Can you provide a scenario when this is going to be used? You have the links where you can see how you exchange values of variavles from child to parent and vice versa, you may need to define two sets of them but that does not limit you already. I am asking because it all looks like now you want a so called "shared memory" implementation (e.g. memory mapped files) that is available out of the box in SSIS, if so this feature does not exist.Arthur My Blog