sql agent job not reading ssis record set object variable

Question

ignore question - found better solution for issue after reviewing logical resources

Answer 1

Sounds like you might not have your package's parameters file set up on the server, but I'm guessing at this point. User::rs_bar means you defined a variable called rs_bar in your package. Are you setting that variable in your package code somewhere? If so then confirm that whatever it is using to get data is set properly on the server.

If you are using package parameters then ensure that your parameters file is being included in your deployment to the server and that the package is using the parameters. See here for information on using the parameters when deployed.