Where do you find this in SSIS (Script task) ?

Thank you for the replies. I ended up using the RightFax .dll

The script task is getting pushed my input variables from my ForEach Loop container. This allows...

yes. One of the first things I tried. Setting the delay did not do the trick.

When sending to the Send Mail task within SSIS, it's expecting a valid format email address. As this is a valid email address within our environment, is there any...

Yes. It needs to be in the following syntax.

[FAX:Jane Doe@555-1212]

OR

[RFAX:Jane Doe@/FN=555-1212]

My apologies.

It's a DOB field being stored as a string. No application is pointing to this data.

Any help is much appreciated.

DOB

I'm using:

DECLARE @CutOff DATE

SET @CutOff = '01/01/2016'

Eirikur worked perfect. It did exactly what I needed it to do. Thanks again! 😀

I wish that was the case. We do our best to get a 4 digit (CCYY). It doesn't always work out like that.

This is exactly what I needed. Thank you!

declare @mycutoff date = '01/01/2020';

select [Date] = CONVERT(VARCHAR(10),CASE WHEN convert(datetime,'7/26/29',1) >= @mycutoff THEN DATEADD(YEAR,-100,convert(datetime,'7/26/29',1)) ELSE convert(datetime,'7/26/29',1) END,103)

Gents - the birthday is 1929 not 2029. I would prefer not to update the server because I don't now the impact.

Yes but the birthday is 1929. That is the problem.

Change the result set from Grid to Text.

Why not do something like this? I did not have SSMS in front me to test, it was done in notepad. Hope this helps or gets you on...