Bulk Insert WMIC output to table w/ xp_cmdshell

Question

Bulk Insert WMIC output to table w/ xp_cmdshell

caffeinated

Ten Centuries

Points: 1271
More actions
September 27, 2007 at 2:42 pm

#177623

Comments posted to this topic are about the item Bulk Insert WMIC output to table w/ xp_cmdshell

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Arnold Lieberman Valued Member Points: 57 More actions · Answer 1

I know this is an ancient post, however I came across it when searching for a way to get process information into SQL Server. This method is fundamentally flawed as it seems WMIC does not format CSV files correctly. It would be much better to go via XML as demonstrated here.