sql server dts: Global Variables in Logging tab -- sql server dts

Global Variables in Logging tab

rajalapati NO[at]SPAM gmail.com
1/9/2007 3:48:08 AM

sql server dts:

Hi all,

I have an requirement to include Global variables in logging tab for
Error file.

for Creating a new connection and the file name i gave global
variable.

Some thing like this

i have

Set oConnection= oPKG.Connections("EVSVER")
oConnection.Datasource=DTSGlobalVariables("FilePath").Value & "\" &
DTSGlobalVariables("FileName").Value

so it was set dynamically

like this i want to set Error file in logging tab which is beside
Global variables tab,which should be some thing like

DTSGlobalVariables("ErrorPath").Value & "\" &
DTSGlobalVariables("FileName").Value

Pls help how to use Global variables in logging tab or what is the
script need to be included in Active Script task

Thank you
Raj Deep.A

Re: Global Variables in Logging tab

Allan Mitchell
1/9/2007 9:03:00 PM

Is this the package logging?

You cannot change the package log file from inside the package for the
current execution as by definition the package has to have started for
it to
run your task and therefore logging should be running already

It will continue to log to wherever it is that was specified when you
saved the package.

If you are logging to SQL Server and want to dynamagically change that
server then what I do is create an alias using CliConfg. This way I
specify the Non-Existent server alias and I leave name resolution to do
the rest

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.