How do I access the build configuration in SSDT, ie SSIS 2012?

• etl.laptop

  SSCrazy

  Points: 2267

  More actions

  September 30, 2013 at 1:23 pm

  #283789

  Alert me | Edit | Delete | Change type

  Question

  You cannot vote on your own post

  0

  I need to do this to solve an excel problem as shown over here -

  http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine

  and here -

  http://ybbest.wordpress.com/2009/07/22/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

  But, I cannot find this "build" menu. Please help me to find the damn thing.

  

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  September 30, 2013 at 1:56 pm

  #1654708

  You're not designing windows forms, you are designing SSIS packages.

  Right click on project, go to properties, go to debugging and set Run64BitRuntime to false.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• etl.laptop

  SSCrazy

  Points: 2267

  More actions

  September 30, 2013 at 2:49 pm

  #1654718

  Thanks. That works well. I followed the online solution and was confused for hours when such a simple thing could have solved it. I would like to thank you by saying -