When I tried to create temp table with the script below in
the package, I got an error " invalid object name: #Heloc
Rates."
I have right to create temp table. Please tell what I did
wrong. I am new to DTS.

Your help is greatly appreciated,
Culam


CREATE TABLE [#Heloc Rates](code_ VARCHAR(15), [desc]
VARCHAR(50))
INSERT INTO [#Heloc Rates] VALUES ('H3', 'Prime Rate')
INSERT INTO [#Heloc Rates] VALUES ('H4', 'Prime Rate')
INSERT INTO [#Heloc Rates] VALUES ('Y1', '2 Yr Treasury')
INSERT INTO [#Heloc Rates] VALUES ('Y2', '2 Yr Treasury')

Is that when you parse the statement ?
Have you tried to run it? Works for me.

--

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


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