Does anyone know of a command or a way of extracting the User ID and/or Name
during the ActiveX script to then use that value to load to the table being
populated by the DTS package?

i.e. we'd like to add the user id as a column on every row to track who
loaded a particular row at any given time.

Jim,

If you had windows authentication in your sql connection then you could use
system_user sql function in the insert/update statements. It is cumbersome
to get the user in ActiveX.

Ilya

"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote