Thanks, that did the trick

Msg 195, Level 15, State 10, Line 4

'GetActiveEventBackOrderUnitsCount' is not a recognized built-in function name.

I removed the alias from my original code and everything worked fine

what I want to do is based on the value from ProjectedTimeTill100PercentSellThrough, in each record I want to update the bit fields.

For example if I have the following row:

ProjectedTimeTill100PercentSellThrough ...

That worked, thanks

ForcastUnitsTimesOMSCost is a float datatype

My bad I used the wrong query:

SELECT ForcastUnitsTimesOMSCost, case when IsNUll(ForcastUnitsTimesOMSCost,0.00) <> 0 then SUM(CTCBOHAndWCSBOHTimesOMSCost/ForcastUnitsTimesOMSCost) else 0 end as Calculation

FROM MyTable

Where (CONVERT(date, GETDATE()) BETWEEN EventStartDate AND EventEndDate)

Group By ForcastUnitsTimesOMSCost...

Thanks Chris that did the trick

Oh nevermind...lol

I'm not trying to return the name of a day. In my query I'm trying to return the boolean value of columns named "Monday", "Tuesday"....etc. My table is

I figured it out. After creating the named calculation in the dsv, I right clicked the dsv and selected "New Measure From Column" and it was added as a measure...

The answer is no, I didnt need a stored proc...but, I did need to add the same ssis variable in as a paramter for the second placeholder (?)

I changed my code to the following to mak it easier to debug...Im posting my error afterwards. The SSIS package is deploy to an integration server:

Declare @TSQLCmd varchar(3000)

DECLARE @startdt DATETIME,...

I'm getting an error saying DTS isnt a command. I can find all kinds of examples on how to execute a package saved as a file but I cant seem...

It returns an int value 1 or 0