This is a more elegant and more readable solution... thanks!!

I found a similar problem on another site that I modified and got to work:

DECLARE @Count2 INT = (SELECT [CallCount]
FROM [a2wh].[dbo].[CallLogCommonCount] Count1
WHERE (2-1) = ( 
SELECT COUNT(DISTINCT(Count2.[timestamp]))
FROM...

Finally got it! this works:

(SELECT Convert (varchar, (SELECT COUNT (*) FROM .[dbo].[Stage_Log] WHERE datestamp = LEFT(CONVERT(varchar, GetDate(), 120), 10))))

The query below works fine now isolated, but it is part of an email stored procedure and I'm getting the error from SQL Agent:

08/12/2021 13:11:45,tel_SMS,Error,2,GSO-SSIS-DEV,Ytel_SMS,Send success email,,Executed as user: NT...

• This reply was modified 3 years, 3 months ago by  DaveBriCam.
• This reply was modified 3 years, 3 months ago by  DaveBriCam.

Never mind the last crisis... fixed... and the Derived Column with just the expression worked perfectly... thanks!

Something really went bad in my VS 2017 SSDT. I went into the advanced editor for the derived column and VS closed, I reopened VS 2017 SSDT and now it...

Dumb question... I can just run the email step as a result of a successful run of the first step.

I too think I feel more comfortable keeping email notification in SQL Server rather than SSIS as I've learned that it is very versatile. The below code actually works for...

Thanks... How do I write to a file in C#? I'm really new to C#

This worked!:

using System.Net;

public void Main()
{
            try
          ...

Just to get the program running I used, reluctantly, a File System Task... and it worked but with limitations. The code I have in the script task is failing to...

• This reply was modified 3 years, 4 months ago by  DaveBriCam.
• This reply was modified 3 years, 4 months ago by  DaveBriCam.

Thanks!... I'm always forgetting "using System.IO;"

I put in the Try/Catch code and the two dts variables, but the C# has errors: "The name File does not exist in the current context.". I have these values...

I like your code but for right now I'm testing the below to simply delete the file. My package running from SQL Agent is reading the file and writing successfully...

• This reply was modified 3 years, 4 months ago by  DaveBriCam.

What code are you using in your 'Archive File' script task?