Some parts aren't entirely clear, but the general idea doesn't seem too difficult.

If you could offer a concrete example, that would make it much easier to help you. (E.g. "I have one column with 3 rows that contain the values 3, 7, and 9. I want to create 3 different insert statements using each of these values that looks like this: INSERT INTO table (col1, col2) VALUES (3, getdate())...")

From what I can gather, it seems like a possible candidate for a ForEach Loop container on an object variable that has had your column of values fed into it. Then within that container, a simple Execute SQL task could take the value in each iteration and construct the insert statement either by accepting a parameter or building the statement out as an expression. You could achieve this in a data flow as well using a flat file source and the SQL command transform, but I have had performance issues with that approach that make me shy away from it now.

Again, a concrete example will better show your goal and intent.