Home Forums SQL Server 2008 SQL Server 2008 - General Pulling my hair on this issue in SSIS (2008 r2):An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Incorrect syntax near the keyword 'SET'.". RE: Pulling my hair on this issue in SSIS (2008 r2):An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Incorrect syntax near the keyword 'SET'.".

  • November 27, 2014 at 5:57 pm

    #1761356

    Hi resender,

    Try using --execute sp_executesql (@SQL)

    Rather than --execute sp_executesql @SQL

    Ta

    David

    ============================================================
    David

    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]