I have a package that I am using to take data from a table in SQL out to an
Excel spreadsheet. However, what I'd like to do is have the package put the
Excel workbook on an individual's desktop. I tried using the %userprofile%
variable but the system is not accepting that. Is there a way to do this, or
would I need to put the spreadsheet on a network share and then launch a BAT
file to move it to the user's desktop?

Thanks in adavance,
Chris

Chris,

Is this the same PC on which the package runs? If that is the case then use
dynamic properties task to read USERPROFILE environmental variable into the
your variable and use ActiveX script task to concatenate '\Desktop' to it .
Otherwise put the file on a share and make a shortcut to it from a user's
desktop. There is not point in propagating a file into a user's desktop
because different users would have different paths in the same PC.

Ilya

"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote