How do I write to the status line of the window from active X in the
Transformation task?

I am trying to print the row numbers as they are processed to someplace
on the window. The status line on the window that display the progress
of the package as it is progressing.

Thanks,

Tom.

You can't AFAIK. That is an MS Exe which uses the DTS Events to manage the
progress.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Thomas Scheiderich" <tfs (AT) deltanet (DOT) com> wrote

To expand a bit on Allan's reply. The progress count comes from the
OnProgress event. There is no way to raise this event from within a
script, but it is available to you if you where to write your own custom
task, but realistically this is a lot more work.

http://msdn.microsoft.com/library/de...en-us/dtsprog/
dtsppropde_00dv.asp

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

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