Here's an article on how to send an HTML formatted e-mail using SSIS:

http://www.mssqltips.com/sqlservertip/1753/sending-html-formatted-email-in-sql-server-using-the-ssis-script-task/

You could create a table in HTML format and put your data in it.

Maybe the data got truncated while writing to the destination...

A bit faster:

DECLARE @dates INT;

SET @dates = DATEPART(yyyy,'10/30/1988');

IF NOT EXISTS (SELECT 1 FROM dbo.period_dim WHERE years = @dates)

BEGIN

-- Complete SELECT statement

INSERT INTO period_dim (col1, col2, ..., coln)

SELECT ...

FROM ... ;

END

Nice question. I immediately chose "yes", because it would have been quite sad if you couldn't force a seek somehow 🙂

Joy Smith San (2/16/2012)

---

I created a new Role and assigned the user to it. Gave Full Control permission and it started working. I did it from SSMS. When I tried...

Revenant (2/16/2012)

---

Grant Fritchey (2/16/2012)

---

Stefan Krzywicki (2/16/2012)

---

Brandie Tarvin (2/16/2012)

---

Can I just say, I hate that nothing dies in Florida? For those of you experiencing winter, please send snow in my direction....

But you do know Google right?

Anyway, here's a link:

http://bytes.com/topic/c-sharp/answers/268038-write-text-file-into-dataset

(Googled for .NET store file into dataset)

Koen Verbeeck (2/16/2012)

---

OK, that won't work in a dataflow with an OLE DB Command, as the sp can probably return more than one line. Next time be a little more...

Yes. In the SSIS expression language, the \ is an escape character. Thus, if you want to have \ in your text, you need to escape it with itself, resulting...

Is something mentioned in the output window?

If you can rename the file locally, check out the File System Task.

It has the option "rename".

Phil Parkin (2/15/2012)

---

A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools do I need?

See the...

I wouldn't do this in SSIS. It is much much easier in TSQL as Jeff has demonstrated.

So you want a dimension just about EmployeeType?

Then indeed set the key to EmployeeType and the name also.

Discard the rest - EmployeeID and Department - as they have a...

What is the encoding of the text file?