Post reply

OLE DB Command

  • April 29, 2008 at 2:50 pm

    #125075

    I have a data flow that directs rows to an OLE DB Command after a lookup in order to update records that have changed.

    The SQL in the OLE DB Command is as follows

    update cdt_Crawford.cdt_SubscriptionType

    set Subscription = ?,

    set MaxCDs = ?

    where SubscriptionType = ?

    I keep getting the following error

    Error at Data Flow Task [OLE DB Command[240]]: An OLE DB erro has occured. Error code: 0x80004005. An OLE DB record is available. Source "Microsoft SQL Native Client" HresultL 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error".

    Any ideas on how to solve this??

    Thanks in advance

  • April 30, 2008 at 3:16 am

    #808873

    Looks like a syntax error. Remove the second 'set' keyword.

    update cdt_Crawford.cdt_SubscriptionType

    set Subscription = ?,

    MaxCDs = ?

    where SubscriptionType = ?

    Peter

  • April 30, 2008 at 3:55 am

    #808889

    Many thanks Peter

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

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