i would guess that although you said the TCP is set up correctly, it sounds to me like one instance is using a dynamic port for connections, and the other...

i don't ask yes or no or fill in the blank questions, i try to make the interviewer talk about the issue and experiences he has with a particular focus.

it sounds much more like you are looking for whodunnit information...like did Lowell access the Payroll database.
just a plain old login audit will only tell you Lowell connected 40...

probably not.
usually when you send an email to a number of recipients, for example to: currentlyValid@email.com;nolongerValid@email.com;, the SMTP server accepts the message, and database mail receives the SMTP...

i think what you want is a data driven subscription.
generate a view that would build all the parameters for all reports, and create a subscription that populates the parameters...

each client that used to connect to the server, if it has a problem, needs to install the updated SQL Native Client.
it sounds like your machine , specifically needs...

if you are using SQL Database mail, you can query the msdb database:
if the smtp server returns an error, like no such mailbox, you can see it in there.

are you using fully qualified names for the DNS? like myServer.AlphaTangoWhiskey.com, or just the name that has to be resolved, like myServer?
can you test and see if it makes...

for your BCP, can you explicitly convert to varchar, so it's not a custom type on exoprt?

here's a complete example like Sue_H is referencing:
sqlcmd -S stormserver\SQL2016 -Q "SET NOCOUNT ON;select TOP 10 * from DBA.dbo.Algorithm" -o c:\data\myfile.csv -h-1 -s","

The parameter flags...

is this a pure bulk insert or a merge component or something?
give is a bit more info onthe package design please.
also , are you using lookups to join...

all those interim versions from 5+ years ago are gone,and only the latest are maintained.
these are the links, which is @ version 3.18, i need to post my latest...

you are trying to access a file in your private protected space
C:\Users\mp88_\OneDrive\Desktop\samplefile.txt

if you ran bcp from the command line itself. YOU have access to that file.
but...

this might be a case of you being familiar with using the Excel automation hammer, and everything looks like a nail....

a lot of what you pointed out can...

I am in the same situation, I have reviewed the answers that you have received but I have only managed to get the procedure executed but no emails come...