Forum Discussion

sdoscher's avatar
sdoscher
New Contributor III
4 years ago

Can I use Dynamic SQL in SnapLogic?

I have a DYNAMIC SQL that I run in SQL Server Query and it runs fine. I am having trouble running the same SQL in the SQL Server - Execute snap.

Can someone guide me on what I might need to do to get dynamic SQL running in SnapLogic.

This is the message that SL produces after running the dynamic sql query.

Thank you.
Scott

1 Reply

  • sdoscher's avatar
    sdoscher
    New Contributor III
    4 years ago

    I cannot get this dynamic SQL query to work.
    DECLARE @sql AS varchar(max)
    SET @sql = ’
    select top 10 * from db1.dbo.hc_table
    ’
    EXEC (@sql)

    It runs fine in SSMS, but not Snaplogic.

    Is there special syntax that I need to use in Execute Snap?