MS Access And SSIS

• Mark Kinnear

  SSC Eights!

  Points: 850

  More actions

  August 13, 2008 at 7:45 am

  #103558

  Can you call an MS Access query from SSIS?

  Ill probably never use it, but just a question...

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 13, 2008 at 8:33 am

  #857470

  I've never tried it, but I would assume that you could. At the very least you could duplicate the query in SSIS to get the data you want.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question