For anyone who might be interested in the above - the problem was with the fact that my Visual Studio is bound to Source Safe.

It seems that if I...

Thought I had better report that this problem has gone away! It looks as if, somehow or other, the SQL Agent job which was

executing the package was running a...

I, too, have a problem with Send Mail Task in SSIS.

I have a Send Mail task at the end of a data transfer package which works perfectly on success of...

Thanks - that's exactly what I was looking for!

Jonathan 🙂

Following on from my query in regards of handling rotation of textual data :-

CREATE TABLE [dbo].[Temp](

[metaid] [int] NULL,

[label] [varchar](50) NULL,

[value] [varchar](260) NULL,

[name] [varchar] (10)

)

INSERT INTO Temp VALUES (3140, 'Recorded...

The examples of crosstabbing given are very good by only work with numeric crosscasting.

If you try a similar method with textual columns you cannot use GROUP BY because you need...

The examples of crosstabbing given are very good by only work with numeric crosscasting.

If the data items in the rows are varchar the only way I have managed to achieve...

Oh!

Thanks for that - it's sort of what I thought and Regedit can't find RICHTEXT.RichtextCtrl anywhere.

My problem is that I don't what to do to install the class. I...

Trying to use the rtf conversion function - not recognising the RICHTEXT.RichTextCtrl class:-

DECLARE @object int

EXEC @hr = sp_OACreate 'RICHTEXT.RichtextCtrl', @object OUT

IF @hr <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object

END

ODSOLE Extended...