Accessing SQL in Transform Data Tasks

#1

Is there a way through ActiveX script to access the SQL in
a transform data task?

#2

In article <0d3401c3a487$0f31fba0$a601280a (AT) phx (DOT) gbl>, Jason_Constant
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Is there a way through ActiveX script to access the SQL in
a transform data task?

From an ActiveX Script Task you change the SourceSQLStatement-

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Accessing SQL in Transform Data Tasks

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

Accessing SQL in Transform Data Tasks - 11-06-2003 , 10:57 AM

Re: Accessing SQL in Transform Data Tasks - 11-06-2003 , 01:11 PM