Configuring file path for log file SSIS
Hi All, I am using script component which logs error details to the log file at the local. The file path is hardcoded now in the script component's script editor. I don't want it to be hardcoded, and want to pick the file path from some configuration file. Can i do this or i need to hardcode the path in the code itself?
May 31st, 2011 11:23am

No need to harcode. Use a package variable that you can set from the configuration and use this variable to drive the logging in the Script Task. Read/Write variables in SSIS: http://www.programmersedge.com/?p=1350 Package Configuration - Package Variables Handling: http://weblogs.asp.net/rrobbins/archive/2009/01/15/ssis-package-user-variables.aspx Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 11:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics