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

14 March 2013 The "component "Extract dates from string dates" (3614)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 The features and interface are very similar when developing reports though. The error I'd get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1....

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 report. If you get the following error (like I did) when you view the deployed report on the Reporting Server: An error occurred during client rendering. An error has occurred during report processing. Cannot impersonate user for data source...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

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

23 April 2013 Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 fields EXCEPT for "ApprovalStatus" and would get the following response when attempting: { "response": { "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7013, "message": "Field name 'ApprovalStatus'...

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

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

404: Page Not Foundhttps://www.joellipman.com/static-items/404.html

11 February 2015 still to be found on our new website at www.joellipman.com. The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Joel Lipman .Com to choose a new direction.

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 but this is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows, both with the typo: ** ** Row1: EthnicCode DnYa **...

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

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 > Click on "Comments & History" Go into Settings > Automations > Workflow Logs > Custom Functions: check if/when they occurred and in relation to what invoice. Source(s): Zoho Community - Zoho Books - Workflow Rule: trigger when a bill is paid, payment...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred to me that perhaps this isn't clearly documented. But there are tips found across the web just not specifically...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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

Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 So I'm getting an error like this: The requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that...

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