SSIS Tutorial Part 47-Use Sub Query in OLE DB Command Transformation with Parameters in SSIS Package

Tx for this, again it would be really helpfull if you can share the source script used to create the tables and Rows instead of us having to create them ourselved. Which is fine in most cases except when the table/data is larger than expected and takes allot if time to do oneself.

Hi, thanks for the example. I have a situation where I want to execute a select statement in an oledb command, the statement will return a single int value and I want to store that value in a variable so I can call it in a derived column. Please can you give insight on how to store the output of the oledb command in a variable? Thank you.

excellent example! simple but not too simple