Bad Directory - DTS - Global Variables

I am trying to set Global Variable that will open a txt file and import the data into a sql table.

I am currently using the sample I found at sqldts.com (Looping, Importing and Archiving).
When I set the variable for filename = dbo.cadfilepath.filename, I get a Bad Directory error.
My filename data is stored in another table - I am looking for the best approach to calling the filename from the table = cadfilepath and opening the actual text file and importing the data into my project table.

ie.
Table = CADFilepath(pathname, projectnum)
Pathname ProjectNum
\\Seasc-Shared\Spln\Shared\Forecast\00000-000.txt 00000-000
\\Seasc-Shared\Spln\Shared\Forecast\00000-001.txt 00000-001
\\Seasc-Shared\Spln\Shared\Forecast\00000-002.txt 00000-002

I want to access the info in CADFIlePath and then open the first record's text file and import this data into my Project Table, then repeat the process until .EOF.

I know this sounds confusing and I can email you my documentation - since this website does not allow for attachments.

Any assistances is greatly appreciated.

Karen