Discussion:
SSIS Package Connection Manager for Comma Delimited Log File
(too old to reply)
jsh02_nova
2009-08-27 18:49:02 UTC
Permalink
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
Todd C
2009-08-28 12:53:01 UTC
Permalink
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
Post by jsh02_nova
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
Loading...