Hi @Amit Rawat ,
Yes, it is possible to connect on-premise SQL Server from Azure Data Factory. All you have to do is to configure a Self-Hosted Integration Runtime. After configuring the SHIR, you would able to use it in the CopyActivity and also in the pipeline. Hope this will help. Thanks!