Victor Gazquez
- Total activity 68
- Last activity
- Member since
- Following 0 users
- Followed by 12 users
- Votes 28
- Subscriptions 22
Posts
Recent activity by Victor Gazquez-
[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...
-
[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...
-
[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...
-
[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...
-
[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...
-
[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 ...
-
[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...
-
[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...
-
Source Types
Solution: DSP Migrate Component: Map Do you know what the possible Source Types in dspMigrate are? Have you ever tried to delete a Source from Map and you couldn’t? If you do not know the answe...
-
[Automation] Considerations in 6.6.0 and 6.6.1
Overview Among the new functionalities in release 6.6, there is one in particular that I want to bring to your attention as it is currently not working as expected. In 6.6, Report Auto Gen Level op...