Yep thats just dawned on me!! Used the derived column function to facilitate that and all works ok. Thanks.

Hi,

Yes, looking at the output file we have and how its currently displayed in its current SQL 2000 table, the last 2 digits appear after the decimal point. If both...

Hello,

Thanks for the above. When loading up character map and finding the U+00A6 Broken Bar, when selecting it then copying it from there, then pasting it over the top of...

Sorry, it was Service Pack 2.

One of jobs was run before the service pack was installed about a month ago, and in the job history it has succeded next to...

Hi, thanks for that.

When trying to connect to integration services on my production server I get the following message:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

Library not registered. (Exception from...