Post reply

Error: Variable "User::user_codes" does not contain a valid data object

  • July 20, 2012 at 2:38 pm

    #264450

    Guys I am getting the following when I was trying to execute my SSIS package.

    Error: Variable "User::user_codes" does not contain a valid data object

    The variable is of data type "object" which gets value from execute sql task with "full result set" output.

    I am trying to use inside this foreachloop container but the package is failing the moment it starts executing for each loop.

    it doesnt even enter into it.

    Can any please help me. Thank you in advance.

  • July 21, 2012 at 4:03 am

    #1515832

    Please post some details of code or snapshots of how you set or use that variable...

  • December 3, 2018 at 10:03 am

    #2015339

    Make sure that your variable that you are using in your Foreach loop is defined as a Object variable for the ADO object source.  Also make sure that the Resultset in your execute SQL Task has the same object variable defined to output the resultset for the ADO object source.

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

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