Post reply

SSIS OLEDB source executing but not returning results

  • March 5, 2013 at 12:38 am

    #394309

    Hi There,

    I have a query in a SSIS package. it has been running fine and returning required results to the destination, suddenly it runs and completes but does not return results.

    Took it out of the package and ran it on the server it does return results.

    any idea what could be causing this?

    it is a straigh forward query with only the period as a parameter.

    Select Col1, Col2, Col3 From Table1 Where Period = ?

    Period is an int in this format 201302. I tried it as string still got no joy.

    Please help as the only other option I'm thinking of is putting it in a stored proc.

    Kind Regards

  • March 5, 2013 at 4:24 am

    #1593399

    Set a breakpoint on the execute SQL task on before execute, then set a watch on the Period variable to see if it's getting populated correctly and step through.

  • March 5, 2013 at 4:39 am

    #1593408

    Hi,

    Thanks for the advise, It really helped to identify the problem. I was assigning the wrong value to the variable

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

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