Aha thanks. Having made those changes now, I can get the link opening in reporting services now but only if the url I'm going to is returned as a field...

Correct, the user exists as a user in the msdb database and I've made sure it exists in the DatabaseMailUser role in msdb. The owner of the database is the...

Forgot to mention, one record already has this set to BAR. I want to be alerted as soon as another one has it set. Not too interested about if there...

I set the permissions for user 'User1' using:

USE msdb

EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole',@membername = '[User1]';

Understood. Thought there'd be a reporting services charting solution rather than a dataset query solution but I've got it to work using your method instead. Many thanks.

This works really nicely setting the office as the detail group. Brilliant. Many thanks.

Oh yeah! Didn't think of doing it that way. Thanks. Thought there would have been an Execute Remainder as well as an Execute Task/Container button!

Stupid one really! Worked it out! It was permission issue on a windows share I was using that caused it!

Problem I'm getting now is I run the package from...

Worked it out through trial and error!!! Worked out that, although the data type on Sybase was Boolean I thought I could map it to bit on SQL but it...

No, not doing that. Trying to put newtime in there i.e. the value that was created by the derived column. Doesn't work either. Not entirely convinced it's this that's causing...

Yeah, but didn't notice anything that jumps out at me. Wish error trapping stuff like this in ssis was more intuitive!

I've attached a sample (3 rows) of the dataviewer...

da-zero (2/26/2010)

---

In a previous post you said that the destination is a database timestamp field.

Do you mean that you use the datatype timestamp in SQL Server? Because that should be...

Yes that's right. Problem is it doesn't load in to my sql table and the errorcode and errorcolumn output isn't very helpful in identifying which column is causing the problem....

DATEADD("ss",TIME / 10000000,(DT_DBTIMESTAMP)"01 Jan 1900")

where TIME is the DT-I8 field I'm converting and the destination is a database timestamp field.

How I hate SSIS error reporting! I don't get any errors now in the design, but I'm redirecting errors in the insert in to my Sql tables, and they're all...