3 kommentarer:

Good stuff. Just a note to anyone using this method. If you set this up in a production environment to run scheduled then make sure to use try catch around the OPENXML/select statement and remove the document in memory even if the select for some reason errors (more probable if you use insert into than select into). It is really frustrating that you cannot remove the document from memory later, the only way to free up that memory is to restart the SQL Server Service.