This is what worked for me as a derived column definition on the DT_WSTR input column:

[OpenDate] == "#EMPTY" ? NULL(DT_WSTR,255) : SUBSTRING([Open Date_2],FINDSTRING([Open Date_2],"/",2) + 1,4) + "/" + SUBSTRING([Open...

I broke this down/simplified it to isolate the source of the issue. The substring function works by itself, but i'm getting "function name not recognized or does not exist" when...

Here I tried to substitute for the variables (slash1, slash2, month, day, YearAndTime) and came up with this crazy long chain of commands, but I'm getting "cannot parse expression" errors.

(DT_DBTIMESTAMP)(substring([OpenDate],...

This is what I came up so far, but I don't know how to combine everything into one line that I could use in a derived column.

slash1 and slash2 are...

I understand that this method might not be a "best practice", but it worked well for my situation.

Your help is greatly appreciated!

Pat

I see what you are saying about a single database failing over (and possibly not being in sync with other SP dbases).

I'm going to research the Log Shipping method. Thanks...

noeld,

If we use high-safety mode database replication with manual fail-overs, would you expect that we would run into issues with views or objects failing if we are only mirroring SP...

Pardon my ignorance, but what are "full SQL Certified Systems" ?

The end goal is to achieve 100% uptime (or as close to that as possible), as we have firm-wide applications that were developed in SharePoint, that need to be up...

I'll give SP3 a try.

Thanks to all for the speedy responses.

I agree about not wanting to modify/add primary keys for fear it might mess WSS/MOSS up. Which brings me to my next post (my attempt at setting up database mirroring).

Should...

Christopher,

The reason for doing this is because we are migrating trouble tickets from an old help desk ticketing system to a new one. In doing so, I am going to...

Thanks for your help. I got this working after removing the AS "Combined_Notes".

I chose this script because I am only going to be running this conversion query one time (today). Once I adjust the time, I intend to do a bulk update...

Looks like all I needed was the following code to update all rows (subtracted 5 hours from UTC time in the opendate column) in the tasks table.

update tasks

set opendate =...