Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Barry Fogarty 493 posts 1129 karma points
    May 01, 2012 @ 15:39
    Barry Fogarty
    0

    SQL syntax error in Exectute SQL package action

    I am getting a SQL syntax error when installing my package.  THe package makes use of the Execute SQL package action to create some tables in the target site DB.  The SQL is simply generated from sql server and it runs fine when I execute it directly against the DB.

    Is it to do with the line breaks perhaps?

    Error in Execute SQL Package action for package DotDigital Appeals 
Manager error:umbraco.DataLayer.SqlHelperException: Umbraco Exception 
(DataLayer): SQL helper exception in ExecuteNonQuery ---> 
System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
Incorrect syntax near the keyword 'IF'.
    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft