There are faster/better ways of obtaining total row counts. Here's one:

SELECT TotRows = SUM(row_count)
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('schemaname.tablename')
      AND index_id < 2
GROUP...

Hi all, I've (finally!) tried to get this working again, this time from my office PC. Unfortunately, with exactly the same outcome.

The SQL Server service is running under the NT...

I'm trying to pass a date to an azure blob storage source within a ForEach Loop and it doesn't look like it takes a dynamic filename.  The ForEach Loop...

Wow, that is one of the weirdest package designs I've ever seen! A source without a destination.

To make this work, please change things around to do things in the standard...

Hi,

I am afraid to disagree with your comments, when i run the package from solution explorer it is success and could see the row got inserted. Also this is...

Hi,

Source is OLEDB, inserting into a table with hardcoded values, this is my first pacakge in 2017. below is the script i had in Source.

I checked reports, all reports...

I think you mean 'spanning'.

I did try to help, but it seems you have not read what I wrote. Please provide the info requested.

Check out the All Executions report for your package and see whether that gives you any clues.

What is the source of the data? Is it a file? If so, this...

You need a GROUP BY

SELECT ID, EmpNo, Date1, SUM(Time1)
FROM [TimeReporting].[dbo].[TimeData]
WHERE Date1 BETWEEN '2020-03-01' 
  AND '2020-03-08'AND EmpNo = '8939'
GROUP BY ID, EmpNo, Date1

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

This --> "a small army of Excel Jockeys" <-- is a truly unpleasant image, I wish I could un-see it 🙂

I've just been having dig around in a test script task and can find no way of changing this, despite changing references, targeted .NET framework and almost every other thing...

What's your question?

In T-SQL, use sp_Send_DBMail (link) to send e-mails.

John, I...