SSIS can't use variables (Flat File > OLE DB Command), Must declare the scalar variable "@"

Question

Apologies, I'm an SSIS noob and I'm struggling with trying to import a flat file and do an OLE DB command WHILE including a variable in the SqlCommand.

You can see my query and the attempt to include an already defined variable. The error is displayed below:

Must declare the scalar variable "@" I understand what the error is saying, but after hours of searching, I cannot figure out how to use variable in the OLE DB Command.

Thanks in advance for any assistance.

Answer 1

Try putting the ssis variable [user::ClientID] into a derived column and add it to the data flow. You should be able to use a ? and assign that value to your query just like any other value in your data flow.