Okay, I did this:

' Copy each source column to the destination column

DTSDestination("MAID") = DTSSource("Col001")

DTSDestination("Mem_ID") = DTSSource("Col003")

DTSDestination("Ac_Ded_Yr") = DTSSource("Col033")

Function Main()

If DTSDestination("Ac_Ded_Yr") <> DTSSource("Col033") Then

Main = DTSTransformStat_ExceptionRow

Exit function

End If

Main...

Not sure where to look?

This is what I did.

I created a DTS job per item.

I scheduled the jobs (this create a SQL Server Agent for each DTS job).

Create a new Server Agent.

Open each scheduled...

Use work flow task.

right click on data transform item, select work flow properties, select the item to execute next.:D

It worked!

THANKS!!:blush:

Okay I'll give it a try.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER view dw_v_IVR_Eligibility as

Select

MC.Document,

Convert(Nchar(14),Replace(MemNo,'*','')) Memno,

Convert(varchar(50),FirstName+' '+LastName) MemName,

Convert(Nchar(8),Replace(CONVERT(NCHAR(10),M.Birth,101),'/','')) DOB,

Convert(Nchar(5),Left(S.Zip,5)) 'Zip',

case

...

I removed the top 1000 and it worked.

I added abs to insure a positive number.

abs(checksum(newID()))

😉

After running several test the top 1000... will not work with the query.

The user name and date is being queried, member quired is not one of the 1000 returned therefore,...

That works also.

I'll use your since!

Thanks!!

Got it!!!

1. create a view

CREATE VIEW vRandNumber

AS

SELECT RAND() as RandNumber

2. create a udf

CREATE FUNCTION RandNumber()

RETURNS float

AS

BEGIN

RETURN 7 + (SELECT RandNumber FROM vRandNumber) * 113.00

...

Has to be numeric....

I tried something like this....

cast(rand()*DATEPART(ms,getdate())*300 as int)

.. it creates a number however the numbers are identical.

I need something that creates a unique number. It does not have to be sequencial...

John, thanks for the quick response.

I do not need to update a table on display data via a view.

More info:

The view will be used by a IVR.

The user will enter...

How do I flush buffer cache?

What does GUI stand for?

How do I review/see these counters?

Consider these counters when checking buffer cache issues:

SQLServer:Buffer Manager (Free Buffers, Stolen Page Count)

SQLServer:Memory Manager (Memory...