@@ROWCOUNT or an output clause will return the inserted record count in your SQL procedure. Assigning this value to an output parameter or just doing a SELECT as the...

Apologies in advance if I've misunderstood your question 🙂

Have you considered implementing an output parameter in the stored procedure(s), which can be used with the Execute SQL task "ResultSet" option...

Have you tried setting the package to run in 32-bit mode? (Project Properties > Config Properties > Debugging > Run64BitRuntime)

I can't remember 100%, but I don't think there's a...

Solution inspired by Paul White's solution at: http://www.sqlservercentral.com/Forums/Topic895462-392-1.aspx

The 999999 value used in the ISNULL expression is arbitrary and just designed to get the whole string when a CR...

Both expressions keyed off GETDATE, but can be substituted if the report needs to appear that it's running on a different date

SQL

SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, DATEADD(DAY, -1, GETDATE())), 0) AS...

Hi Mark,

Have you tried building the project (in Project Explorer window) before exiting the script editor? I find my freshly added references disappear if I don't remember to do...