It's solved.  Had 2 SQL Server disks and was able to rebuild the SQL Server registry with the second one

Thanks. I forgot to delete this from the system, but I solved it.

oPKG.GlobalVariables("sFilename") worked

Thanks for the follow up Will. I actually figured it out in that I just used this notation

oPKG.GlobalVariables("sFilename") = f1.name

and in the child package the DTSDestination... worked fine.

I have...

The first piece worked, now I am trying to add the second layer of logic which is prorating based on start dates: This is what I have and it...

Thanks, that solved it

Thank you to everyone. I actually solved this a while ago with a set level solution. However, problems with the database are causing me to have to parse...

Thank you, everyone, I came up with a set level solution for the whole piece