SSIS will be difficult to use for this, since the data fow cannot handle changing metadata.

I would simple import the queries from the flat file into the database, loop over them and put an appropriate INSERT statement before each one.