Re: Help with DTS

#1

I would probably break this into 2

Get your @date into a Global variable in the first step. (assign to a
variable)

select convert(varchar(9),dbo.getwkendingfiledate(max(wee kending)
),112) as dt from dbo.archive where ( loc_id = ?)

Use it in the second.

--

Regards

Allan Mitchell

Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

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

Quote:

Hi,
I am trying to create an SQL task with the following

declare @date smalldatetime

select @date =
convert(varchar(9),dbo.getwkendingfiledate(max(wee kending)
),112)from dbo.archive
where ( loc_id = ?)

INSERT INTO dbo.archive
SELECT loc_id,

filename
@date,
current_timestamp as DateCreated
FROM dbo.anotherarchive
WHERE (loc_id = ?)

I get the error syntax or access violation error.

Any ideas?

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

Re: Help with DTS

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

Re: Help with DTS - 12-22-2006 , 04:56 AM