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 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 connection manager but this is inefficient and...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 to ZohoCRM. How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: Type FTP in the filter field in the top right and there...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 data with statistics and datasets. Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I train OpenAI on a dataset, can that data be accessed by external sources? No, if you train...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 a version suitable to your system Install it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC) Click on the System DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name (should be system name followed by...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h...

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

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 So this is an article to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable...

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

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

11 February 2023 Maximize: This is a formula which returns pretty realistic images and references as demo'd in Maximize's Youtube video (see sources below): Type of photography, lens, distance, subject, direction, type of film, aspect ratio Glibatree: The following are...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 as an Admin with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select "Zoho Analytics Workspace" as the data source type. Select the relevant...

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

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

09 March 2011 on two words soundex value and compare these. // Be warned that it does go off track though in terms of relevance... Sources: iamcal.com Nadeau Software

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

SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 to Microsoft and Stack Overflow, your reporting server needs to have the "unattended execution account" configured. Some sources are specific saying that the account will need to be able to logon to the external server holding the files. MSDN Quote:...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 Studio Unable to restore database "..because it is in use by this session." determine who is connected to sql database Sources Microsoft Developer's Network

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line. Other Sources: Download Microsoft Windows Server 2003 Resource Kit Tools (for Robocopy)

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 link; } public String getDate() { return date; } public String getDesc() { return desc; } } My rss_item.xml (reduced down): Sources: Android Research Blog - Creating A Simple RSS Application in Android Android Research Blog - Creating a Simple Rss...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 publicly accessible link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work despite being as per the documentation (see sources below). Here's the code for our function; note it is within ZohoBooks and not ZohoInventory (moved) and the connection...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a...

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