Hello, Andrew!

Your source statement should be


Select * from Table 1 Where Field2 = ?

You can then map your parameter (?) to a global variable



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: I have a Execution Task, in wich the work (I have "delete * from Table1
: Where field1=Parameter1")

: but then i have a Transformation (the black arrow between 2 connections)
nd
: it doesn't recognizes it

: ("Select * from Table 1 Where Field2=Parameter1")

--- Microsoft Outlook Express 6.00.2800.1158

Thanks Allan

Now, i've created a global parameter "MyString" as "qwerty"

in a data pump task, i have
"select * from Table1 where table1.field1<>?"

I press the "parameters" button, map the parameter to the global variable,
but when i press "Preview results..." i get an "Ssome parameters havn't a
specified value"....

Any ideas?



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> escribió en el mensaje
news:%23ikRnyXQDHA.2852 (AT) tk2msftngp13 (DOT) phx.gbl...

OK

Don't waoory about it. The parameter val is passed at runtime


--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Andrew Ofthesong" <Andrew (AT) NoSpam (DOT) net> wrote