Hi @Harsha Reddy Dubba ,
As far as I know, AAD account is only used to connect to Azure SQL Database.
If you want to connect to SQL DB on pre in SSIS package, you could only use SQL Server authentication or Windows authentication like shown below.
Could you please have a check of the issue so that we could do more analysis.