Re: Automatically create table name
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 9 Jul 2005 11:14:17 +0100
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B165AD1-3BC4-4341-A9C1-8706E1B12651@xxxxxxxxxxxxxxxx
> 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
>
.
- References:
- Automatically create table name
- From: Kris
- Automatically create table name
- Prev by Date: Re: Using DTS to "move" (not COPY) source data to destination
- Next by Date: Re: ASP.NET and C#
- Previous by thread: Automatically create table name
- Next by thread: Re: Automatically create table name
- Index(es):
Relevant Pages
|
