Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming flat is required, the following 10 results were found.

  1. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

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

    I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." Browse to the first file in the folder to loop through and select it. Set the connection manager name, specify...

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

  3. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2 double-quotes to a string of your choice...

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

  4. SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    "" : LTRIM(This_String) LTRIM(This_Date)=="" ? (DT_DATE)"1900-01-01" : (DT_DATE)This_Date -- last column when datasource is flat file (account for line break): ISNULL(Last_Column) ? "" : TRIM(Last_Column) Last Troubleshooting Check: The problems here...

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

  5. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    award-winning photograph, Canon EOS 5D Mark IV DSLR, f/8, ISO 100, 1/250 second, close-up, natural light, professional, flattering, headshot::3 black and white, grainy, deformed, watermark::-2 photo: ::5 Artistic Photography::4 creative, expressive,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *

  6. How to grow potatoes in potato planter bagshttps://joellipman.com/articles/_other-misc/how-to-grow-potatoes-in-potato-planter-bags.html

    I live in a flat but I'm lucky enough to have a balcony which gets some sun. Bought some potato patio planters and found this good video on youtube... {youtube}Q3zoVolI-Sw{/youtube}{youtube}Q3zoVolI-Sw{/youtube}{youtube}Q3zoVolI-Sw{/youtube}

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

  7. Checklist for the local computer repairshttps://joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

    Newsletter Business Cards Extra RAM (to charge for) Extra Cables (again to charge for) Service: Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  8. Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

    = $0020 Const TBSTYLE_TOOLTIPS = $0100 Const TBSTYLE_WRAPABLE = $0200 Const TBSTYLE_ALTDRAG = $0400 Const TBSTYLE_FLAT = $0800 Const TBSTYLE_LIST = $1000 Const TBSTYLE_CUSTOMERASE = $2000 Const TBSTYLE_REGISTERDROP = $4000 Const TBSTYLE_TRANSPARENT =...

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

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

    eg. "Andrew Lloyd-Webber", "Marketing Manager (Acting)", "Lipman***Test" or "R&D". As well as alphanumeric values such as "Flat 4B", "Suite 4899A", "123A Myhouse". Example #2: Using as a Custom Script Component The above will work as a SSIS Script task....

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

  10. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    if you want to change this. OriginalProper-Cased JOHN SMITH-JONESJohn Smith-Jones HEAD OF IT SERVICESHead of IT Services FLAT 123AFlat 123A MRS. O'CONNOR-MCDONALDMrs. O'Connor-McDonald ORG_DEPT_STATUSOrg_Dept_Status SEND.HELP.NOWSend.Help.Now PO BOX...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 1 - 10 of 10

Joes Word Cloud

Please publish modules in offcanvas position.