Preferred option would be to make the Java app perform the notification itself.

Use a non-locking record count technique, such as

SELECT TotRows = SUM(row_count)
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('schemaname.tablename')
...

Thanks all. Here is the SSIS expression for those who only need to use SSIS, DATEADD("hh",17,(DT_DBTIMESTAMP) ( (DT_STR,30,1252) (DT_DBDATE) (DATEADD("dd", -1 - (DATEPART("dw", getdate()) % 7), getdate()) ) )...

Well done on providing the DDL for the table.

Would you also be able to provide some sample data, along with desired results, based on that sample data?

The sample data should...

I don't think that this is...

I need my child packages to run in parallel (multi-threading)... They're loading lots of data and I can't wait for one to finish before starting the other. I've tried...

The Agent service account.

Don't think you can. Precedence constraints are the answer – what is the reason for you not using them?

Thanks, Jeff. The date processing capabilities in T-SQL are significantly more powerful than those built in to SSIS (though, of course, SSIS has native access to .NET libraries through C#...

With @year being defined as an Integer rather than a datetime.

If you are running some SQL which returns a result set of T-SQL queries, the answer is yes.

Return the result set to an Object variable, which should be shredded within...

• This reply was modified 7 years ago by Phil Parkin. Reason: Fix typos

So you want an expression which returns a datetime of 5pm last Friday, is that it?

Your expression returns a datetime, as can be seen below:

"Also 2) i want to find last friday until 3 pm." This makes no sense to me, can...

• This reply was modified 7 years ago by Phil Parkin. Reason: Additional text

When composing a query in SSMS, just drag from the 'Columns' node of the table you want (in Object Explorer) to SELECT from onto the editing window – SSMS will...

• This reply was modified 7 years ago by Phil Parkin.

Like this?

WITH ExpiredDates
AS (SELECT m.CustomerID
          ,m.DateCreated
    FROM #MYTABLE m
    WHERE m.EntryType =...

• This reply was modified 7 years ago by Phil Parkin.

Hi,   Thank for you confirming that, I did indeed search but wanted to clarify and see if anyone had a workaround. Sorry for troubling you. Have a good...