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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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