SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Disable User Registration in Joomla 1.5 - Configuration Filehttps://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database to the Joomla 1.5.x website Browse the table "jos_components" (or "#__components" where "#_" is the site...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 to show you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 { # remove terms that are not long enough (so no searches for the letter "e") # remove terms that are in the omit word database if ((!in_array($term, $omit_search_words))&&(strlen($term)>=$MinimimumStringLength)) { $omitted_words_array[]=$term;...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment and features found inside the room. Problem #1: More of an aesthetic problem than functional...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 sometimes) Service Transition Security rights/roles in the system (reasons for different accesses) Get all known logins (database, ftp, sftp, ssl, site logins: test & admins) List all files, their purpose (consider a spreadsheet of all active/legacy...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 to unlock the record they are viewing". "Oh that person isn't at work today". "Well someone on that computer has locked a database record.". "Well my colleague who's using that computer is in a meeting but I can login and do this for you". IT Policy: Do...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 305 2010 479 Report 001 202 2011 84 Report 002 202 2011 45 Report 003 287 2011 94 A working example using the ReportServer database in SSRS 2008 R2: SELECT Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors advised that if we had time in the future we could...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB