• Thanks Koen. I have gotten a little further.

    When I chose a variable where I hard code the same value I am creating as the variable I wish to use, the command does work as an expression using an IN qualifier.

    However, when I change the expression command to use the variable that is empty prior to the package running, I get the following error when I assign the SQL Command variable.

    An OLE DB record is available. Source:”Microsoft SQL Server Native Client 11.0” Hresult: 0x80040E14 Description: “Incorrect syntax near ‘?’.”.

    It appears the SQL command from variable cannot validate the variable used in the where statement, because the value is not set prior to run time, and the SQL command needs it? I have delay validation set to true on the data flow task this command is being run in, and that did not seem to help either.