Using variable in system stored procedure

#1

Hi,
I need to import an excel file every month. The excel file should be imported into a table named 'NewInforec', and the existing table should be renamed to 'NewInforec_(month -1)

At this time I have this code

DECLARE @month INT

SET @month = DATEPART(mm, GETDATE())

DROP TABLE NewInforec_ol

EXEC sp_rename 'NewInforec', 'NewInforec_' <---Here the month variable should appear

CREATE TABLE [NewInforec] ( .........

My question is now: How do I put @month variable at the end of 'NewInfore_' ??

I am sure this is simple for guys like you to explain this to me

TI

/Gulkings

#2

You can build up the statement in an Active Script task

Global Variables and SQL statements in DTS
(http://www.sqldts.com/Default.aspx?205)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

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

Quote:

Hi,
I need to import an excel file every month. The excel file should be
imported into a table named 'NewInforec', and the existing table should be

renamed to 'NewInforec_(month -1)'

Quote:

At this time I have this code:

DECLARE @month INT;

SET @month = DATEPART(mm, GETDATE());

DROP TABLE NewInforec_old

EXEC sp_rename 'NewInforec', 'NewInforec_' <---Here the month variable
should appear !

CREATE TABLE [NewInforec] ( .........)

My question is now: How do I put @month variable at the end of
'NewInfore_' ???

I am sure this is simple for guys like you to explain this to me.

TIA

/Gulkings

#3

Surely, there must be a more simple way of doing this ??? I am using SQL Server 7.0

----- Allan Mitchell wrote: ----

You can build up the statement in an Active Script tas

Global Variables and SQL statements in DT
(http://www.sqldts.com/Default.aspx?205

--

---------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP
www.allisonmitchell.com - Expert SQL Server Consultancy
www.SQLDTS.com - The site for all your DTS needs
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or

"gulkings" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:BAB3B771-EBFA-4C41-9718-F742DBFEF346 (AT) microsoft (DOT) com..

Quote:

Hi
I need to import an excel file every month. The excel file should b
imported into a table named 'NewInforec', and the existing table should b

renamed to 'NewInforec_(month -1)

Quote:

At this time I have this code
DECLARE @month INT
SET @month = DATEPART(mm, GETDATE())
DROP TABLE NewInforec_ol
EXEC sp_rename 'NewInforec', 'NewInforec_' <---Here the month variabl
should appear
CREATE TABLE [NewInforec] ( .........
My question is now: How do I put @month variable at the end o
'NewInfore_' ??
I am sure this is simple for guys like you to explain this to me
TI
/Gulking

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using variable in system stored procedure

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using variable in system stored procedure - 03-01-2004 , 02:41 AM

Re: Using variable in system stored procedure - 03-01-2004 , 04:16 AM

Re: Using variable in system stored procedure - 03-01-2004 , 05:16 AM