Hi I have a SSIS project to convert data from one Database to another database and want the end user to see destination record befor they can be inserted into destination database and select all record that he wants to be written to the destination database.

Actually in SSIS solutions, you shouldn't implement any interactive mode ! I mean " want the end user to see destination record befor they can be inserted into destination database and select all record that he wants to be written to the destination database " doesn't make sense when you work with SSIS Packages. SSIS Packages are for transfer data usually in schedule in low load times. But if you need to make something interactive you can, Just note that SSIS doesn't made for this purpose! for interactive thing it is better to write an application with .NET language which is more robust in interactive environments.http://www.rad.pasfu.com

Thanks for the answer, but in my scenario, this is a small interactive part of a big otherwise autonomous conversion, so the custom .Net application is overkill. Just in this small part, there is no autonomous way to decide if a row should be transfered. any help is appreciated.

I think it is better to write all records which needs to be checked by user in interactive mode into a new table, and also put an extra bit field in that table in database, then write a simple .net application to load all data from that table and show in a grid, then user can check any rows which he wants to import . then in a SSIS Data flow task, you can fetch data from that table where the bit field is true. please let me know if you need more details on each part.http://www.rad.pasfu.com