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 where the column widths match. How? I've adapted my real working product with an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example...

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

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 the tools I had (Android Studio) which is why I've written this article. Start "Android Studio" Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a relatively old version of the Android OS: Add an...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank project which does not include code from the previous example but you can still build this over the previous example (as I did)....

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 key doesn't just contain the private key we need. It is a JSON file with links to the public key, as well as info as to the project ID, the client ID, the client Email... Stuff that this script will use so: // Get JSON file (generated by Google)...

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 Multitasking ms-settings:multitasking Night Light Settings ms-settings:nightlight Phone ms-settings:phone-defaultapps Projecting to this PC ms-settings:project Shared Experiences ms-settings:crossdevice Tablet Mode ms-settings:tabletmode Taskbar...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 and we are currently logging time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every Friday at 08:00 in the...

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

Border settings not saving in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 that a grid would show for empty spaces. I wasn't getting very far because I'd even ask the border to be grey and save the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then...

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

SSRS - Lost window with datasetshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars...

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

Deserialization and cannot checkout files in TFShttps://www.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *