Hi,
Can someone please help me with the following
I have to create a table & it should have get date() with it. For example
Table Nmae: CustomersOct16.
I am building a DTS package. Due to large volume of data I am partitoning
the Table on weekly basis. Data load comes in each week therefore when I run
the package automatically
a partitioned table should be created with get date. Can any one please
show me with example/ Syntax how to create such table. Or is there any other
way to create automated partitoned tables. An example with syntax will be
very helpful

Thanks

Steve

What about something like

declare @tblStmt varchar(255)
set @tblStmt = 'CREATE TABLE partition' + CONVERT(CHAR(8),getdate(),112) +
'(col1 int,........)'
print @tblStmt

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


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