Hi,, I am SSIS2005 i have a flat file name ABC_2012-08-08 i am loading data from flatfile to oledb destination i want to create dynamically destination tablename (ABC_2012-08-08) Thanks Ram

Hi, Load this name into variable. Create a full create table script and store it in another variable. You can create table before the data flow task using execute SQL task and use create table script variable. Now, in data flow task oldedb destination editor, select "table name or variable-fast load" for data data access mode. The only thing to note is the datatypes of column should be same each time. Also, set delay validation property for data flow task to TRUE.- Chintak (My Blog)