title: As BIDS 2008 is only 32 bit how can we develop for 64 bit?
body: <p>I am working to get my packages running on SSIS 2008 64 bit. My pacakges used DSN so I made 64 bit DSN.. but as BIDS is only 32 bit I run into error like below.</p>
  
  <p><img src="https://i.stack.imgur.com/dwZQ7.png" alt="enter image description here"></p>
  
  <p>I think .Net Provider\Odbc Data Provider is 32 bit (as it is part of BIDS 32 bit) but My DSN is 64 bit so error. What can be solution to this problem?</p>