Hi,
I have a DTS package that creates a CSV file.
In it, I have an Execute SQL task with the following code:
drop table mytabletemp
declare @wkenddate datetime
SELECT *
into mytabletemp
FROM othertable
where this=that
and wkending = @wkenddate
order by
update mytabletemp
set amount = amount * 100
ALTER TABLE mytabletemp ALTER COLUMN amount numeric (19,0) NOT NULL
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mytabletemp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[othertable]
CREATE TABLE [dbo].[othertable]
w all my table settings
When I click the PARAMETERS button, to define my wkenddate parameter, it says "the SQL statement does not contain any parameters".
Um, yes, it does.
This code works fine in Query analyzer.
Whats wrong?
Thanks much,
Mark
DTS parameter problem...
Posted - 03/14/2013 : 10:13:24
