I've created a Dynamic Properties Task that uses global variables to
substitute the server name and database name into the connections and tasks
of my DTS package. The global variables worked great for setting the
server name property of the connections (which were values), but now I have
a property for my task that's a SQL statement like "delete from
[DestinationDatabase].[dbo].[PM00100]".

Is there any way to embed a global variable into the query for
DestinationDatabase? If not, what are my options?

I'm using constants for my global variables.

Build it up in an Active Script task

Global Variables and SQL statements in DTS
(http://www.sqldts.com/Default.aspx?205)



--
--

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

"David Morrison" <me (AT) nospam (DOT) com> wrote

Can you direct me to a good source for figuring out how to do that? I'm not
familiar with scripting languages.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

The article I posted will do it for you.

A good site in general is www.SQLDTS.com

--
--

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

"David Morrison" <me (AT) nospam (DOT) com> wrote