Friday, September 13, 2013

SQLSaturday 250 - Basic SSIS Best Practices

Thank you to everyone who attended my SSIS best practices presentation today!  I hope that you found it useful and are able to apply something from it to your SSIS development.

Below are links to the slide deck and a ZIP file containing the 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 I used.

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

Presentation slides

Demos zip file