Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this task, you build and run the SSIS project. If you have the 64-bit version of Excel 2010 installed on your computer, you should set the value of Run64BitRuntime to False for the Excel source to work.
In the Solution Explorer window, click Project on the menu, and click CleanseAndCurateSuppliers Properties.
In the Properties dialog box, expand Configuration Properties on left, and click Debugging.
Set Run64BitRuntime to False.
.jpg "CleanseAndCurateSuppliers Project Properties")
Click OK to close the Properties dialog box.
Click Build on menu bar and click Build CleanseAndCurateSuppliers. Make sure that there are no build errors.
Click Debug on the menu bar and click Start Debugging.
Review messages in the Progress window and verify that package executed and ended successfully.
.jpg "Results from Progress Window")
.jpg "Final Status from Progress Window")
Click Debug on menu bar and click Stop Debugging to stop the debugging session. If the package fails, you should enable data viewers and see how the data flows between components.