Import data from Word Custom Controls

• pietlinden

  SSC Guru

  Points: 63572

  More actions

  May 24, 2019 at 3:50 pm

  #3647032

  I'm just wondering how hard this would be in SSIS... I got it to work in Access using Word automation/VBA (dirty word, I know!) I can loop through the Word file's ContentControls collection and map the names to fields in my table. Has anybody done this in SSIS? The lack of branching in Access is a hassle. Besides, I'd rather create a job and have the package basically monitor one or more folder and just import/shred the files into the database when it finds them.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 25, 2019 at 4:10 pm

  #3647252

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.