Hi Gail

So do I, anyway Microsoft would never give us buggy code, would they? 😉

While I applaud your belief in a purest approach to database design, I will not be...

Hi Jeff

I also believe that good design has its own pay-offs, in particular down the track when something goes wrong troubleshooting a well designed database is much easier than one...

Hi Gail

Thank you very much for your comments, they are very helpful. One little point is that in a data warehousing situation you honestly believe that we're going to add...

Thank you for your comments Gail, I always thought that good design was a basic requirement for good performance? Your comments suggest that good performance is not necessarily dependent...

Hi

This link looks useful, but unfortunatly it suggests using '+' as a concatination, which Oracle doesn't support, and it has the parameter without single quotes which oracle expects to be...

Thanks for that, I'm not sure that Books on Line advice about putting the values in a table are that helpful for SSRS, but it's good stuff in general.

thanks

Thanks for that, I have checked in the Agent properties>history page and the option to clear the history is not set.

To try to track it I ran a job every...

Hi There

I like the way you think, but the configuration is very carefully the same in both environment, I will check the statistics, which I should have done before.

Regards

Andy

Hi There

I have this issue, but I get no logging of any errors in the Windows event log or in the SQL Server logs, infact the last error log in...

Thanks, I was under the missguided impresion that SQL would track the space on the disk as well, silly me;-)

I am going to change the query so that the null is not returned, but it would be nice to have the option when nulls are encountered and changing the...

Since the Microsoft web site acknowledges that this can be a problem I use the derived column task to change the format to yyyy-mm-dd. This is the only format that...

SSIS is not a SQL Tool but a .Net tool therefore how it works is more akin to C# or VB

Just to answer my own post - I found the solution was to set the permission level to unsafe in VS2008 project properties database tab. This adds the assembley with...

Hi Steve

Thats great but the error message I get is in the event viewer application log, does that mean there is no more detailed message?

Andy