sql server dts: See if this helps: http://www.sqlis.com/default.aspx?27

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Stephen Lonsdale" <StephenLonsdale@discussions.microsoft.com> wrote in
message news:5B167E33-F2F3-4C83-803F-F206BEAC7B3B@microsoft.com...
Hi,

I have a DTS package that will implemented on several network configurations
and would like to use a 'path variable' to replace the string that is
entered
when defining the error text file. (depending on the implementation I am
directed by the DBA or network admin to use specific locations for logging
output). I would like to define this 'path variable' once in a control
package and have it available for other packages.

many tia

Stephen Lonsdale

Hi,

I have a DTS package that will implemented on several network configurations
and would like to use a 'path variable' to replace the string that is entered
when defining the error text file. (depending on the implementation I am
directed by the DBA or network admin to use specific locations for logging
output). I would like to define this 'path variable' once in a control
package and have it available for other packages.

many tia