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...

there is no need to install office on a server.
SSIS will use the ACE drivers to create excel documents, so there is no need to install  Office , and...

something like this should work:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
GO

IF OBJECT_ID('tempdb.[dbo].[#Results]') IS NOT NULL
DROP TABLE [dbo].[#Results]
GO
CREATE TABLE [dbo].[#Results]...

restore the  table from a backup. you have permanently converted the previous data to bad data/question marks instead of retaining the original values.
Turkish characters sets use  

February 12, 2019 at 7:04 am