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, 4 months 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...

You can potentially shortcut John's method. If you add or subtract 10000 to an INT date held as YYYYMMDD, you are effectively adding or subtracting a year.

(If one of your...

there are 2 things - historically we've been told to use table variables as they can "sometimes" be in memory (no one has ever given me details on when...

This is interesting ... I usually head from table variables to temp tables. Are you finding improvements across the board (ie, for all temp tables), or just in certain scenarios?