Search - Joel Lipman .Com

1. SSIS Multiple Lookups in one: / SQL Server Integration Services /; What? A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" ...; Created on 05 August 2014
2. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; What? This is an article to 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 ...; Created on 13 June 2014
3. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue: / SQL Server Integration Services /; ... Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages ...; Created on 09 June 2014
4. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under ...; Created on 03 June 2014
5. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "I ...; Created on 04 October 2013
6. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line Feed -- CHAR(13) = Carriage Return And in SSIS: TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", ...; Created on 14 May 2013
7. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output ...; Created on 23 April 2013
8. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
9. SSIS Convert a string into a date: / SQL Server Integration Services /; ... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...; Created on 14 March 2013
10. Mississippi Blues: / Hobbies /; Showing how you don't need the thinnest fingers to play some amazing blues. TTXah51r55; Created on 28 October 2009
11. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data ...; Created on 02 July 2024
12. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... to sign in to their domain registrar's website and need to be assisted, perhaps via a remote session, on setting these up. If they have someone or a company which manages their domain, then they can give ...; Created on 04 May 2023
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ) == "assistant") { // // add the answer text to the response map v_Response = m_Choice.get("message").get("content"); } } } } else { // store in response text v_Respon ...; Created on 06 March 2023
14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices { if(!isnull(m_Choice.get("message"))) { if(m_Choice.get("message").get("role")=="assistant") { // / ...; Created on 13 February 2023
15. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... subdomain) you want to use: Then click on "Save". If you have access to the DNS manager for the subdomain/domain of your customer portal, or you have the customer on a remote assist who has access ...; Created on 17 November 2020
16. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Focus assist ms-settings:quiethours ms-settings:quietmomentshome Graphics Settings ms-settings:display-advancedgraphics Messaging ms-settings:messaging Multitasking ms-settings:multitasking Night ...; Created on 30 July 2020
17. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... and compatibility with future AutoHotkey releases. #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir ...; Created on 28 January 2019
18. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep ...; Created on 18 August 2014
19. Convert to Proper Case in T-SQL: / Transact-SQL /; ... will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You ...; Created on 04 June 2014
20. Proposed Budget i3 PC under £200: / IT Support /; ... (inc. VAT) Total £122.44 (exc. VAT) £146.93 (inc. VAT) Prices do not include the Operating System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred ...; Created on 26 January 2013