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
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, September 13, 2013
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:
http://www.microsoft.com/download/en/details.aspx?id=13255
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:
http://www.microsoft.com/download/en/details.aspx?id=13255
Subscribe to:
Posts (Atom)