Notes on using the samples on this site are below. I would be grateful if read them before contacting me with any issues.
SQL Server versions used
All the SSIS packages that are presented on this site are either in a SQL 2008 format for a 32 bit OS, or SQL 2005 format for a 32 bit os – the version available will be specified. SQL 2005 packages will be automatically upgraded to SQL 2008 on opening. Unfortunately SQL 2008 packages cannot be used on machines running SQL 2005 or earlier, and 32 bit versions of packages may not behave perfectly on 64 bit installs.
Many of the samples make use of the AdventureWorks sample databases, which are available from Codeplex. Any such packages will need to have the connection managers configured to point at your copies of these databases. Often when opening the packages for the first time they will take a while to validate as they are trying to connect to the BI Monkey’s server path, and this will raise errors in the packages. The easiest way to remove these errors is to open the package, change the connection manager, save, close and reopen the package.
Some samples use the BIMonkey database, which is just a working database to play around in. Any packages referencing this will contain scripts to create the databse objects required. You can either add the BIMonkey database to your server, or change the connection manager to point at a database you do not mind having objects created in.
Text Files etc.
If sample files are included – text files, spreadsheets etc. they should be placed in “C:\BIMonkeySamples” before opening the packages. Again, if you want to put them somewhere else, don’t forget to update the connection managers referencing the files.
404 / Dtsx in Browser
If you get a 404 Page not found or the package displays as XML in your browser , remember you may need to right click / save as to download the sample to your PC. If that doesn’t work, please notify me in the comments and I will fix it. WordPress occasionally messes with the links as part of its archive process, though I do try to keep an eye on this.
Still not working?
If you have any other problems with using the samples or have any technical queries, please let me know either in the comments or mail me at the admin address for the bimonkey.com domain.