Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Using SSIS Kinsgwaysoft to not update a value if it is not null RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm new to DCRM and Kingswaysoft, so please forgive me if there is an easy answer.

    I am using SSIS with Kingswaysoft to run an update to the Incident entity.  I would like to Update the field Title if there is no value in it, but don't update if there is a value.  Basically:

    UPDATE Incident

    SET Title = NewTitle

    WHERE Title IS NULL

    I am using Kingswaysoft's CRM Destination Componant Editor to do this, but I am not able to find where I can get the same logic as the "WHERE Title IS NULL".  Using Upsert it would seem like I could change the "Update" column from "Yes" to "No", but it isn't changeable.  When I use a simple Update, I do not see where I can skip the update if the title is not null.

    Any help is appreciated.

    Thanks!



    Friday, February 3, 2017 5:32 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    I would suggest adding an OLE DB Source with the above query to retrieve the records where Title is null, thereafter the Dynamics CRM Destination could use an Update action for the required records.

    Regards
    Anthony

    Monday, February 6, 2017 8:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for your response.

    The problem I run into with this is that I have to use the CRM Incident table to determine which records have a NULL title, but the true datasource is a query from a separate server.  I'd thought about handling this by adding the servers as Linked Servers, and that way I could join the source query to the Incident table to only bring back the records with NULL titles, but for security reasons we try to limit Linked Servers, so I was hoping there was another way to do this.

    If I'm missing something, please let me know.

    Tuesday, February 7, 2017 7:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Filter record in you source connection and update in destination

    Regards Faisal

    Wednesday, February 8, 2017 9:53 AM