June 14, 2011 at 12:49 pm
I am working on a SSIS package. I have given an absolute path to the log file. For portability, I need relative path for the log file. I tried '..\..\Visual Studio 2005\projects\Prj1\Proj1\bin\logfile.txt' and many other options. It is not taking and giving 'file path not found' error. Please help me. The actual file location is:C:\Users\yani\Documents\Visual Studio 2005\Projects\CustomerDatabaseProject\CustomerDatabaseProject\bin\CustomerLog.txt
June 14, 2011 at 1:51 pm
Use a connection for the log file and use an external config file or SQL Agent job property to override the connection properties to match whatever environment the package is in. No need to hard code that in the package at all.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 15, 2011 at 8:49 am
Thank you for the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply