Hi Bill -- If you haven't finished yet.  I wrote a function that fills in dates:

create function fnDateFill(@startDate datetime, @endDate datetime, @recurrence varchar(10))

returns @dateTable table(selectDate datetime)

as

begin

declare @tempDate datetime

if @startDate > @endDate...

Here is a solution for the WHERE clause using a variable turned off or on.  The solution for the ORDER BY might be a problem if you don't want an...

Doesn't the answer have a syntax error ?

Boy, I tried and tried to get this to work just using a transform data task.  I couldn't and it still bugs me.  If you didn't find a work around...

You can use a dynamic query.

Try something like this:

create procedure sp_test

@datefield varchar(20)

as

set nocount on

declare @queryString varchar(200)

set @queryString = 'select '+datename(dw,@datefield)+' = ''a value'''

execute(@queryString)

execute sp_test '07/19/04'

execute sp_test '07/20/04'

execute sp_test '07/21/04'

You should...

Have you tried to uncheck the "use fast load" found in "Transform Data Task properties" "Options" tab?  I did a quick test and my trigger fired when I did.