SSIS with dynamic quey

  • i am modifying a SSIS package which contains SQL task, a dynamic query, and set the query as output parameter, it used to work last week, but today it has problem, the error is:

    "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

    if i modify the query final as execute dynamic query then fine, however when i changed its output as parameter, then prob comes again? can anyone help?

  • ...changed its output as parameter...

    Can you please explain what you mean by this?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • nightowl23 (9/14/2015)


    i am modifying a SSIS package which contains SQL task, a dynamic query, and set the query as output parameter, it used to work last week, but today it has problem, the error is:

    "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

    if i modify the query final as execute dynamic query then fine, however when i changed its output as parameter, then prob comes again? can anyone help?

    Quick thought, has the data changed so now it would be returning more than one row? Parameters don't generally like multiple rows.

    😎

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

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