| Author |
global variables with the utility DTSrun
|
|
|
| I am launching DTSrun using global variables with /A. I have to pass the
parameter "col1=col2" I have a problem: it only passes col1. Everything that
comes after the sign = is not taken.
I lauch dtsrun /Sbase /E /Ndtsname / Avarfilter:8=col1=co
l2
What can it come from ? I tried replacing the sign = by "like" and it works
Thanks in advance for your help
--
mehdi
| |
| Allan Mitchell 2005-09-17, 3:24 am |
| Not sure you will ever get it to work like this
From what I read of your problem you are trying to set col1 = col2 and I
presume they are database attributes?
If yes then how would the package know on which connection to look?
Which DataPump task?
The "value" is meant to be a literal value.
The assignment you are trying to do should be done in the SQL Statement
itself.
Allan
"mehdi" <mehdi.achour@free.fr(donotspam)> wrote in message
news:FE957B1D-4A70-4E47-9E62- DE5146AB93B3@microso
ft.com:
> I am launching DTSrun using global variables with /A. I have to pass the
> parameter "col1=col2" I have a problem: it only passes col1. Everything
> that
> comes after the sign = is not taken.
> I lauch dtsrun /Sbase /E /Ndtsname / Avarfilter:8=col1=co
l2
>
> What can it come from ? I tried replacing the sign = by "like" and it
> works
>
> Thanks in advance for your help
>
> --
> mehdi
| |
|
| Hi,
In fact, the global variable "varfilter" is assigned the value: col1
instead of
col1 = col2.
Have you go an idea? Is the symbol = aspecial caracter and should be
enclosed with some special quotes or other?
At the end, I reconstitute a SQL Statement that I excute and it works fine
when I assign the value col1 like col2 to varfilter
Thanks for your help
--
mehdi
"Allan Mitchell" wrote:
> Not sure you will ever get it to work like this
>
> From what I read of your problem you are trying to set col1 = col2 and I
> presume they are database attributes?
>
> If yes then how would the package know on which connection to look?
> Which DataPump task?
>
> The "value" is meant to be a literal value.
>
> The assignment you are trying to do should be done in the SQL Statement
> itself.
>
> Allan
>
>
>
>
> "mehdi" <mehdi.achour@free.fr(donotspam)> wrote in message
> news:FE957B1D-4A70-4E47-9E62- DE5146AB93B3@microso
ft.com:
>
>
>
| |
| Allan Mitchell 2005-09-21, 8:24 pm |
| Oh so this is so that you can rebuild a statement?
Then wouldn't it be something like this
..../Avarfilter:8="col1=col2"
Allan
"mehdi" <mehdi.achour@free.fr(donotspam)> wrote in message
news:3964949F-4A17-4554-83C2- AF76692AC87A@microso
ft.com:
[color=darkred]
> Hi,
> In fact, the global variable "varfilter" is assigned the value: col1
> instead of
> col1 = col2.
> Have you go an idea? Is the symbol = aspecial caracter and should be
> enclosed with some special quotes or other?
>
> At the end, I reconstitute a SQL Statement that I excute and it works
> fine
> when I assign the value col1 like col2 to varfilter
>
> Thanks for your help
>
> --
> mehdi
>
>
> "Allan Mitchell" wrote:
>
>
> I
> Statement
>
> the
> Everything
> it
>
|
|
|
|