hi,

according to beezells answer:

if i use a sql task to create a new table in a ssis package, how can i save the name of this table to a global variable?

i'm trying to import serveral excel files. i already created the loop to do this.

but since this is a job that has to be done every month, i need a new table to every month.

what i wanted to do was a put a sql task in front of the excel importing loop to create the table and to assign the table name to a variable, so i can use it for the ole db destination.

anybody an idea how to save the name of the in the sql task created table?