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

05 August 2014 "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 system. For...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in SITS, and you use...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 ** ** Created On: 29 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 { // get the value we want to transform inputValue = buffer.GetString(inputBufferColumnIdx[x]); // set the staging value string ValueToConvert = inputValue; // PRIMARY transformation (lowercases and capitalizes first letter taking into account...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a place to introduce it. On...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a...

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