My environment is:
- Windows 7 Pro (64-bit) workstation
- SQL Server 2012 client tools
- Visual Studio 2010 with SQL Server SSIS components
- Data source is Sybase Advantage data folder (32-bit )
- Data destination is SQL Server 2008 R2 server (64-bit)
I built the intial package using the 32-bit import export wizard. I have made some edits in "BIDS" and tried a test run, but I received the typical 32 execution error message. I would have gone to the solution property page and changed the runtime property, but the 2012 property page is not the same as when I had the 2008 client tools installed. I must be missing something silly, but I just can't sort it out.
Thanks very much, and have a very happy New Year!
Please open the properties for your SSIS project and setting the Run64BitRuntime property on the Configuration Properties | Debugging tab to False, you can refer to: http://my.safaribooksonline.com/book/databases/microsoft-sql-server/9780735669895/iidot-development/id896313
TechNet Community Support
Thank you, Eileen!
Yes, I see the screen in the eBook, but that's my problem. I am not seeing that version of the screen. Under Configuration properties (left pane), there is only Deployment. Debugging isn't an option, and therefore runtime property is available. I am begining to wonder if my installation failed in some way; I didn't have to do anything special when I installed VS 2010 over SQL 2008 client tools. But now I have removed the 2008 SQL tools and installed 2012, I am left short.