I have a question regarding the solution to this. I too have found it
necessary to hardcode the [Database].[dbo].[TableName].

How can I perform the following (still using the DTS designer inside
of the Transform Data Task Properties) and not have to hard the
[Database].[dbo]???

SELECT T1.field1,
SS.field2,
T1.field3
FROM Table1 T1
LEFT OUTER JOIN [Database].[dbo].[TableName] SS ON SS.fieldx =
T1.fieldx


I would like to be able to set this using a global variable or dynamic
property? The table that I am joining on is the destination table
that is set in this process.

Thanks for any help along these lines!!!

In message <f1efd3cc.0404051504.661a1492 (AT) posting (DOT) google.com>, SSE01
<sse01 (AT) sbcglobal (DOT) net> writes
In your case you need the DB name, Joseph culd do with out it. Since
object names are not supported parameters either in T-SQL or OLE-DB
parameter support you will have to do this the old way -

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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