Renaming table creating it with DTS package
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!
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL