I am using a DTS package to import my data into a SQL Server. This data
is log information from a firewall. I have a number of firewall boxes. After
the DTS package is done I would like to be able to RENAME the TABLE with
a stored procedure or something to identify which firewall it came from and
then import other log files using the same DTS package.

Any one know a good way to do this??

I really need help!