Lowell (12/6/2016)

---

the error message you pasted was

which would be an SMTP service exists, but is not available.

so the issue is not database mail,...

ZZartin (12/6/2016)

---

Wait do you mean this is an instance of SQL Server installed on your personal PC that you are trying to run this against?

My guess would be that the...

--work file

--USE msdb

--GO

--exec dbo.sysmail_start_sp

--exec dbo.sysmail_stop_sp

--use master

--go

-- exec sp_configure 'show advanced options', 1

-- reconfigure

-- exec sp_configure 'Database Mail XPs', 1

-- reconfigure

SELECT * FROM msdb.dbo.sysmail_profile...

Chris Harshman (12/1/2016)

---

the obvious answer would be sp_send_dbmail:

https://msdn.microsoft.com/en-us/library/ms190307.aspx

I prefer to use the @attach_query_result_as_file=1 option, because the results are often easier to read in the text file than in the body...

Thom A (12/1/2016)

---

Ok. That's a good start. What your reasoning for choosing to do this via SSIS? I asked as send dbmail is very good at achieving this, especially as...

Thank you for your help.

What was I thinking.

I do need to read from a query and send the results as an e-mail attachment or in the body of the message.

My...

Thom A (12/1/2016)

---

Welsh Corgi (12/1/2016)

---

Thom A (12/1/2016)

---

All you've asked is "How do you get all...

Thom A (12/1/2016)

---

Welsh Corgi (12/1/2016)

---

Thom A (12/1/2016)

---

All you've asked is "How do you get all...

Thom A (12/1/2016)

---

All you've asked is "How do you get all the rows from a...

DamianC (12/1/2016)

---

With ssis you can

Create an sp that performs your select.

Use the sp as the source using with result sets followed by all the columns you require along with their...

Thom A (12/1/2016)

---

All you've asked is "How do you get all the rows from a...

Thom A (12/1/2016)

---

That article there is talking about returning a single row and then inserting those values into variables. Is that your aim here? Your title says that you want...

I just ask for guidance.

I think that it is pretty clear what I want.

Luis Cazares (12/1/2016)

---

Welsh Corgi (12/1/2016)

---

ok, I'm sorry for not being clear.

The following article is great but it does it drops off on returning full record set.

https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

I need to get the...

ok, I'm sorry for not being clear.

The following article is great but it does it drops off on returning full record set.

https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

I need to get the result set into a...