Sunday, October 23, 2011

Basic SSIS Best Practices

Thank you to everyone who attended our SSIS Best Practices presentation today! We hope that you found it useful and are able to apply something from our presentation to your SSIS development.

Below are links to our slide deck and a ZIP file containing our demos if you would like to try running them on your own. The demo files are set up to run in a C:\SSISDemos\ folder. If you run them from a different location you will just need to modify the paths to the Excel files. The demos also assume that you are running SQL Server locally (localhost), and that will need to be modified if that isn't the case. A SQL script has also been provided in the ZIP file that will create the SSIS_DEMO database and tables that we used.

Please feel free to e-mail us at the e-mail addresses in our slides if you have any questions or if you need any assistance getting the demos running.

Presentation slides

Demos zip file

Also, there was a question about importing data from Excel with SSIS on a 64-bit server and the Microsoft Access Database Engine 2010 Redistributable (ACE OLE DB driver). The download is available from Microsoft at: