Unrecoverable Parse Error

[chaoconnor]

Good morning!

I'm trying to parse a text file that contains a list of database object names. The process works fine till it reaches a write to text file step and then I get the following errror:

Building project step 'Create RawAll.sql File'...
Step default property 'Filename' = 'C:\Temp\RAW_SQL.txt'
Error expanding macros in property Text: <Error parsing macros: Unrecoverable Parse Error at position 919 - expecting percent_sign>
Step 'Create RawAll.sql File' failed
Build ended.


What's so perplexing is the MARCO that fails is different each time. For instance, one time I may have successfully parsed 100 file names, the next I may only get 20, etc. The list of names does not change, it's been the same since I started.

Any ideas? Thank you!