If you are using a parameterized query as a data source in
Transform Data Task, is it possible to retrieve the actual
sql statement sent to the server (with the parameters
resolved)?
Using the "SourceSQLStatment" property, retrieves the SQL
with the parameter placeholders (?) instead of the
parameter values.

Thanks
Serge

Yes

Use Profiler.

You could also

Read the SourceSQLStatement. You then need to read the
InputGlobalVariableNames, which is a ; delimited list of GV Values. Match
the first ? to the first value you come across and then the 2nd etc etc.



--

----------------------------
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



"Serge" <serge_delic (AT) hp (DOT) com> wrote

Thanks Allan.

Profiler won't work since the source is Oracle, not SQL
Server.

Serge