Hi All,

I want to rename table automatically .How can i do this ?

from example table name is Customer --> wants to rename every day as

Customer --> Customer_20050708 on next day
Customer --> Customer_20050709

any help ..
Thanks

I am not sure what you want here

1. DTS to do a table rename only?

I presume you would want a Customer table empty afterwards right?

Have you looked at SELECT INTO followed by a TRUNCATE ?

2. You want to have DTS populate a new table everyday which has a name
change?

Simply rename the DestinationObjectName of the DataPump task. If the
structire is the same you're done.

3. You want DTS to create a new instance of the Customer table, named
accordingley and populate that through DTS?

You can issue a CREATE TABLE statement that has been built in an Active
Script task and then change the DestinationObjectName of the DataPump task
to the new object name.


A few options there as I am unsure as to what you actually need.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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

the sp_rename stored procedure can help you:
http://msdn.microsoft.com/library/de...ra-rz_3ns5.asp

exec sp_rename 'Customer_20050708', 'Customer_20050709'



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

Why not just add the date as a column with a default of
CURRENT_TIMESTAMP? Much more convenient than creating a table for each
day.

--
David Portas
SQL Server MVP
--

Hi Kris,
You can create ActiveX Script and use something like this:

' To keep history of all files with date attachments to the file name
' Filename format - \\Server\Drive\Folder\Filename_YYYYMMDD.txt
'Start of destination file name
strFilename = "\\Server\Drive\Folder\Filename_"
'Add 4 digit year + 2 digit month + 2 digit day to file name
strFilename = strFilename & Year(Now()) & Right("0" & Month
(Now()),2) & Right("0" & Day(Now()),2)
'Add file extension to file name
strFilename = strFilename & ".txt"

sSourceFile = strFilename
sDestinationFile =strFilename & "_old" & ".txt"
Regards,
Ilin

Kris wrote:

--
Message posted via http://www.sqlmonster.com