Victor Gazquez
- Total activity 68
- Last activity
- Member since
- Following 0 users
- Followed by 12 users
- Votes 28
- Subscriptions 22
Activity overview
Latest activity by Victor Gazquez-
Victor Gazquez created a post,
[Automate] Troubleshooting
Solution: DSP Version: 6.7 Component: Automate As continuation of my previous post , [Automate] Getting started, I want to complement it with a basic guide about some of the most common error/que...
-
Victor Gazquez created a post,
[Automate] Getting started
Hello everyone, I've been lately asked about Automate, so I've decided to start with a simple post, reusing some work that my colleague Karl Boseley has done in our project. The online help it con...
-
Victor Gazquez commented,
Thanks Michael, I would like to add that there are two additional options that we can use if we are using DSP 6.7.1 or higher. These are: <EMPTY> , in case you need '' instead of ' '. I find this p...
-
Victor Gazquez commented,
Thanks Michael for the article, Do you know if is possible to add an external link like an URL? Regards
-
Victor Gazquez created a post,
[Collect] Add column with default value while reading the source table with Collect
Solution: DSP Version: 6.6 Component: Collect and Assemble I have received a question regarding my latest post, [Collect] How to merge tables. In that post, we used the property “Target Delete Wh...
-
Victor Gazquez created a post,
[Collect] How to merge tables
Solution: DSP Version: 6.6 Component: Collect and Assemble I have recently worked in a request from the client that I would like to share with you as it has a few small functionality within Colle...
-
Victor Gazquez created a post,
[SQL] How to easily convert DATES
Solution: SQL Server In any migration project, the transformation of dates is a common task. There will be many occasions, when you will have to change the format to fit with the target requireme...
-
Victor Gazquez created a post,
[SQL] Case Sensitive and Collation Implication
Solution: SQL Server In addition to my previous post: https://support.syniti.com/hc/en-us/community/posts/360000812268--SQL-Search-for-patterns-and-Collation-implication I would like to add that ...
-
Victor Gazquez created a post,
[SQL] Search for Patterns and Collation Implication
Solution: SQL Server Creation of reports where we need to search for characters, words or patterns is a very common task in any Data Migration project, or many others, where we need to do some data...
-
Victor Gazquez created a post,
[How To] Export Reports with Technical and Translated Column Headers
Solution: DSP Version: 6.6 Component: Transform and Assemble To generate target export reports with two headers, technical field and field description, you can use the Export Type = Local file to...