Avatar

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
  • Avatar

    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...

  • Avatar

    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...

  • Avatar

    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...

  • Avatar

    Victor Gazquez commented,

    Thanks Michael for the article, Do you know if is possible to add an external link like an URL? Regards

  • Avatar

    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...

  • Avatar

    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...

  • Avatar

    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...

  • Avatar

    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 ...

  • Avatar

    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...

  • Avatar

    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...