title: How to use SSIS to delete rows from a local table based on conditions from remote?
body: <p>I have a Data Flow Transformation which uses SQL Server source and SQL Server destination(two separate servers). I need to Delete rows from Target SQL Database based on a condition using a table from Source. I don't want to use the Linked servers as it will become a dependency for deploying the SSIS project also access rights issues. </p>
  
  <p>If it is SSMS, I believe I must use the linked server, is it possible to avoid linked server with in SSIS? </p>
  
  <blockquote>
    <p><strong>The smaple TSQL is</strong><br/>
    DELETE T2 FROM dbProd.dbo.Table2 T2
    <br/>JOIN LINKED_SERVER.dbStage.dbo.Table1 T1 ON T1.RowID = T2.RowID</p>
  </blockquote>
  
  <p>I would be grateful for any helpful answer.</p>