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 28, 2014 at 2:23 am

    #1761389

    quackhandle1975 (11/27/2014)

    Hi Resender, to get more help you may need to repost (for the t-sql code)

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

    qh

    I just had a look at my post & I saw a mistake,instead of code="sql", I used quote=sql

    dbalmf (11/27/2014)

    Hi resender,

    Try using --execute sp_executesql (@SQL)

    Rather than --execute sp_executesql @SQL

    Ta

    David

    Tried that didn't work

    Eventually I found that changing the ole db connection manager solved the issue,still it was not a helpful error message as it kept sending me in the wrong

    direction.