I think all you need for the Monday case in the expression box would be:

DATEPART("dw", GETDATE()) == 2

We have a mandatory "retreat" where we go for offsite for 4-5 days. If I was single, it would be great. As a family man with young kids,...

Thanks Scott!

Seemingly random behavior with a random explanation. Could someone provide a valid explanation?

The only way I know would be to have the Execute SQL task use a Variable as the statement source. Then you could inspect that variable at runtime as...

Right click on the task and add a Breakpoint on Pre Execute. While its executing you can see the variable values in the Locals tab that usually appears at...

Reporting Services has the functionality to send reports via email subscriptions and rendered in a variety of formats. The only thing I see in your original request that would...

Is Reporting Services not an option for you? It does most everything you are asking for.

Not sure I follow, but what if you got rid of the @'s for sorting:

select

*, REPLACE(REPLACE(versionval, '@', ''), '@@', ''), CASE CHARINDEX('.', REPLACE(REPLACE(versionval, '@', ''), '@@', ''))

WHEN 0 THEN...

this is a known bug:

search "SSIS - SQL Server BIGINT doesn't map to INT64"

on https://connect.microsoft.com/default.aspx

workaround is to use STRING

You can use 2 variables and a Foreach Loop Container that cycles through the file folder. Setting varFullFileName in the Foreach Loop and varFullFileNameLatest by an expression like:

@[User::varFullFileName] >...

Because there is no column "joined" on, its a cross join. All records in table A join to all records in table B, resulting in a cartesian product. ...

Here's an attempt:

DECLARE@median SMALLINT

, @denseRank SMALLINT

SELECT@median = CEILING(MAX([RowNum])/2)

FROM(SELECTROW_NUMBER() OVER (ORDER BY [FireCentreName]) [RowNum]

FROM[FireList]) median PRINT @median

SELECT@denseRank = MAX(dR)

FROM(SELECTDENSE_RANK() OVER(ORDER BY [FireCentreName]) [dR]

FROM[FireList]) denseRank PRINT @denseRank

SELECTf.[FireCentreName]

, f.[ProjectID]

, f.[DisplayName]

, DENSE_RANK() OVER(ORDER...

i've used an expression to do this, but had the benefit of a file name in the format of filenameYYYYMMDD. in the for each loop assign the file name...

i'm fine with whatever chair you'd like to get, as long as its not made of nauga...please "Save the Nauga" (http://www.gwinslow.com/gw/naugas.html)