Call a stored procedure from ASp.net .Stored proc can call dtexec using xp_cmdshell.

This(dtexec) will run your SSIS package.

Cheers

Sid

Can U write a sql query in Destination using SQL Command.Something like

Select xyz from mn where xyz in(Select Top() from opp) order by desc.This will give you the smallest or...