question

I would recommend you check the commercial COZYROC SSIS+ library. It includes superior REST integration technology where you can build your custom configurations to connect to any REST API.

Was able to achieve it.
Below is the code for reference to others.

         try
         {
             string connetionString = null;
             string sql = null;
             var serializer = new JavaScriptSerializer();

             string serviceUrl = "APIURL";
         HttpClient client = new HttpClient();
         client.BaseAddress = new Uri(serviceUrl);



         var byteArray = Encoding.ASCII.GetBytes("UserName:Password");
         client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", Convert.ToBase64String(byteArray));
         connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName; Trusted_Connection=True;";
         string APIUrl = "/controllers/vertx/hotschedules/getConcepts";
         var response = client.GetAsync(APIUrl).Result;
         if (response.IsSuccessStatusCode)
         {
             var result = response.Content.ReadAsStringAsync().Result;

                 var dt = serializer.Deserialize<Dictionary<string,

                   string>[]>(result);

                 using (SqlConnection cnn = new SqlConnection(connetionString))

                 {

                     cnn.Open();

                     sql = "insert into dbo.Concept (ExtID,Name) values(@ExtID, @Name)";

                     foreach (var item in dt)

                     {

                         using (SqlCommand cmd = new SqlCommand(sql, cnn))

                         {

                             cmd.Parameters.Add("@ExtID", SqlDbType.NVarChar).Value = item["extId"].ToString();

                             cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = item["name"].ToString();

                             int rowsAdded = cmd.ExecuteNonQuery();

                         }
                     }

                     cnn.Close();

                 }

                 Dts.TaskResult = (int)ScriptResults.Success;
         }
             //Dts.TaskResult = (int)ScriptResults.Success;
         }
         catch (Exception ex)

         {
             Dts.Events.FireError(0, "Fire Error", "An error occurred: " + ex.Message.ToString(), "", 0);
             Dts.TaskResult = (int)ScriptResults.Failure;
         }