sql server dts: Hi!

How do I display a status message in DTS? I'm cycling through hundreds of
input files and I want to be able to show the user which file is currently
being imported. I know I can call MSGBOX in VBScript, but the user will have
to press "OK" for each file, which is not what I want.

Thanks for all your help!

Greg

I suspect that you could do this somehow with a Visual Basic program. You would have to trap some events in that program (I'm not sure which). You would need to push some values (like file name) into a global variable, which you would read in the event handler. Then the Visual Basic form could display the current information.

Russ

In message <AA9A5552-B1AC-47EA-8B6A-DE3FD65995CF@microsoft.com>, "Russel
Loski, MCSD" <RLoski@NSPMhotmail.com> writes
[quoted text, click to view]

It really depends on how you execute the package and how you wish to
present the info, but as Russ says, if you used VB (or another COM
compliant language), and included the package event handlers, for each
event or, for a defined event, or a defined event on a defined task, you
should be able to read task/step/package properties and display them in
a progress dialog fashion.

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

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