Hi, I am fairly new to the SSIS thing here but I am having trouble calling a variable that I have created.
My package looks in a directory to import multiple excel files and to do this I use a FOREACH LOOP Container. I have put in that foreach loop a variable name and in the connection manager also and so far it imports all the excel files into sql table.
My problem is now is that I want the package to write to a table the name of all the excel files it has imported into SQL. I thought I would be able to do this within the FOREACH LOOP container but im struggling to find anything that can help me??
Any ideas would be great.
Thanks
My package looks in a directory to import multiple excel files and to do this I use a FOREACH LOOP Container. I have put in that foreach loop a variable name and in the connection manager also and so far it imports all the excel files into sql table.
My problem is now is that I want the package to write to a table the name of all the excel files it has imported into SQL. I thought I would be able to do this within the FOREACH LOOP container but im struggling to find anything that can help me??
Any ideas would be great.
Thanks