Hi:

I want to use a global variable setting in Data Pump Tasks and Execute
SQL Tasks. Is there a way to do this other than using a '?' in the
WHERE clause? i.e. I want to use the variable in the SELECT part of the
SELECT statement. So something like this (which isn't possible):

SELECT ? AS BeginningDate, Field 1, Field 2
FROM TestTable
_____________

Thanks!
Kayda

In message <1105652525.632737.313920 (AT) f14g2000cwb (DOT) googlegroups.com>,
shop (AT) pacifictabla (DOT) com writes

That should work. As a rule if you can use a variable in T-SQL then you
can use a place holder in DTS. Sometimes the design-time validation is
too strict but you can fudge it. Use some SQL that has the same
meta-data (variable setup), but then change it via Disco Edit.

An example of this fudge is described towards the end of this article-

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org