A transport-level error has occurred when receiving results from the server.

I am making a website in which i need to load xml file from url.i am getting the into dataset but it is not able to save into database.i am getting the following error....

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

below is my private method which i had been calling from page load

private void filloperatorcode()
{
    DataSet ds = new DataSet();
    SqlDataAdapter da;
    SqlConnection con;
    con = new SqlConnection(@"Data Source=;Initial Catalog=;Integrated Security=True");
    ds.ReadXml("http://letitgo.asia/api/serviceData.go?apimode=test&goid=5011000001&password=test123&rtype=xml");
    SqlBulkCopy sbc = new SqlBulkCopy("Data Source=.;Initial Catalog=test;Integrated Security=True");
    sbc.DestinationTableName = "r_servicefamily";
    con.Open();
    sbc.WriteToServer(ds.Tables[0]);   //This is the place where i am getting the error
    DropDownList1.DataTextField = "service_family";
    DropDownList1.DataValueField = "service_family";
    DropDownList1.DataSource = ds;
    DropDownList1.DataBind();
    
 	
}