Yes! thanks it worked:). Believe or not but these two lines where commented out on my code :w00t:

WMWeekNbrBuffer.AddRow()

WMWeekNbrBuffer.WMWeekNbr = Ctype(Me.Variables.WMWeekNbr, String)

Thanks again Dr.

I did something similar where I could change the source of the file dynamically. I basically added a variable to the package called FilePath then in the DataFlow I selected...