dbTalk Databases Forums  

global variables with the utility DTSrun

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss global variables with the utility DTSrun in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mehdi
 
Posts: n/a

Default global variables with the utility DTSrun - 09-15-2005 , 12:21 PM






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=col2

What can it come from ? I tried replacing the sign = by "like" and it works

Thanks in advance for your help

--
mehdi

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: global variables with the utility DTSrun - 09-17-2005 , 02:38 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 (AT) free (DOT) fr(donotspam)> wrote


Quote:
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=col2

What can it come from ? I tried replacing the sign = by "like" and it
works

Thanks in advance for your help

--
mehdi


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.