Hi I was hoping from some help with a SISS package I have created.
In the control flow I have a foreach loop container and I have that loop storing file names to a variable. In my events handlers box I have an execute a sql statement so that the goal is that it can write the contents of that variable to a table. However I have not been able to call this variable and I take it I have gone completely the wrong way about this, Can anyone help?
In the control flow I have a foreach loop container and I have that loop storing file names to a variable. In my events handlers box I have an execute a sql statement so that the goal is that it can write the contents of that variable to a table. However I have not been able to call this variable and I take it I have gone completely the wrong way about this, Can anyone help?