Automatically Deleting A Line From Xml Before Running T-SQL

I have an SSIS which goes to a web hosting site and gets the store xml file, saves the file on my computer. Then I want to run a T-SQL script but if fails because the files contains DOCTYPE StoreExport SYSTEM http://store.yahoo.com/doc/dtd/StoreExport.dtd>

I want to manully remove then line before running the T-SQL script. Here is the beginning of the script:


DECLARE @x XML

SELECT @x =cast(bulkcolumn as XML)

FROM OPENROWSET(BULK 'C:databasexmldtdyahoostore.xml', SINGLE_BLOB) AS x


I thought the cast statement would get rid of the line, but it does not.

Any suggestions?

Thank you
LadyDee