Currently receiving error for log file creation upon package start.
Are environment variables supported for path determination of log file? Is
there a special syntax to use for the log file path?
Would like to use %USERPROFILE%\Desktop\Log.csv

You can use the Configurations manager and retrieve config values from XML
docs, SQL Server, Parent Packages, and yes, Environment Variables. Assign the
value to a string Variable in the package.
(for help on Configurations, see by blog: http://toddchitt.wordpress.com/)

Then, click the Log File Connection Manager, and in the Expressions
property, set up an expression for the Conenction String property as:
[User::MyVariable] + "\\Desktop\\Log.csv"

(NOTE: The \ is a reserved character so must be 'escaped', hence the double
\\)

HTH

=====
Todd C


"jsh02_nova" wrote: