Pass Table name as variable in SSIS

hi all,

   having file name t001_2014_07,how file name , create table same file name in runtime,pls me,

thanks

do know table structure same?

the starting point read file name variable. (for each control flow task work).

from there can either use script component create sql creating table or can use variable concatenation. either way, build sql command creating new table , assign code variable.

in data flow task, can select table name from  variable selecting target table. likewise, data source task can set pull table name variable.

if need further assistance, please post. :-)

SQL Server  >  SQL Server Integration Services