Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2012

Reading Excel into SSIS via OpenXML Scripting

Reading Excel data isn't easy.  It should be, but there's a lot of unfortunate barriers in the way that I've discussed before.  They boil down to one main reason: Excel wasn't created for IT, it was created for business users.  We're quite obviously an afterthought.  That said, we're much moreā€¦

Read more

9 comments, 2,437 reads

Posted in Todd McDermid's Blog on 31 July 2012