Post reply

KingsWaySoft Premium Service Lookup Error: Must Specify atleast one output colum

  • April 6, 2024 at 8:55 pm

    #4408317

    Hi Experts,

    I have developed one SSIS package which watches a remote folder for  .csv files and read them  and then get lookup id where its required using KingsWaySoft Premium Service Lookup and then finally map values to CRM attributes in CRM Destination component.

    Now this all works smoothly when I run in Local system.

    After deploying this to SQL Server   and validate it or Execute it, I get following error for the lookup

    lookup failed validation and returned validation status "VS_BROKEN"

    "Must specify at-least one output column"

    I have been struggling to get it resolved but  I am stuck here. I have tried to delete the lookup component and add freshly again and again, changed the way it filters. But nothing worked.

    Kindly let me know if there is any way we can get around this?

     

  • April 7, 2024 at 8:22 am

    #4408419

    Is the version of SQL Server the same on the local machine and the server?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • April 7, 2024 at 1:08 pm

    #4408463

    Thanks allot for reply @Phil ,  Yes its same,

    Also I suspect this might be due to expired license for Kingsway Soft. I raised this concern with  management.

     

     

  • April 8, 2024 at 7:45 am

    #4408681

    prashanth.kamasamudram wrote:

    Thanks allot for reply @Phil ,  Yes its same,

    Also I suspect this might be due to expired license for Kingsway Soft. I raised this concern with  management.

    Sounds like you've found the problem!

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply