Hello, I am getting very frustrated! I have got a Foreach loop container which I am processing files within a folder. I have a flatfile connection manager which I have set up using a test file and have updated the expressions attribute to be the package variable I set up in the collection for the loop container however everytime I run it I get the error: 0xC0202094 cannot retrieve the column information from the flatfile connection manager. I can only guess that it is either the variable being passed to the connection manager or the way I set up the connection manager. When I msgbox the variable in a script component before the dataflow step, the variable for the file seems fine. Any suggestions are REALLY appreciated.
Yours
Jayne
Unable to retrieve column information in Flatfile connection within foreach loop container
bhv
Jayne,
I can't tell what the problem is I'm afraid. However, I have a downloadable demo here:
Enumerating files in a Foreach loop
http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx
of this working. You may wish to take a look and figure out your problem by comparing the differences between the two.
-Jamie
OsoPolar
Thanks very much for your reply... I've had look and there are no discernable differences. For what I can guess is that something is wrong with the column information being set in the connection manager. I created it on a test file, and then set the expression in the connection manager to connection string= 'filename' (which was set in the container). Either there is a problem with the file name or it has lost it's column information when i set the connection string to the variable 'filename' .
On a side note - I am also running a script that opens the flatfile and reads the header record to capture a date. I am closing the file before moving onto the data flow step, however I wonder if this might be causing a problem But from running the container, it appears to get through the script fine and falls over at the flat file step in the data flow.