declare @Xml_prod xml

select @Xml_prod= cast(c1 as xml) from OPENROWSET (BULK 'C:\xmldownload\adzunajobfeeds.xml',SINGLE_BLOB) as T1(c1)

Msg 6365, Level 16, State 1, Line 1 An XML operation resulted an XML data type exceeding 2GB...