The [font="System"]'data_file'[/font] argument to OPENROWSET(.. BULK.. ) must be a quoted string literal, it cannot be a variable or an expression.
Although Help and BOL are not entirely consistent, usually when you see an argument or parameter specified like [font="System"]'arg_name'[/font] it means that it has to be a quoted string literal, such as [font="Courier New"]'c:\foo\bar.txt'[/font].
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]