The only method I have been able to successfully write in geography data was to have the table schema already defined with a geography column and then 'APPEND' the data to it. Anytime I would try with OVERWRITE it seemingly changed the data type to string.