Probably

Thanks, fixed.

Prizes sent. Let me know if you get them. I assume Yahoo sends a trophy?

New thread for 2017 - http://www.sqlservercentral.com/Forums/Topic1846421-61-1.aspx

chrisn-585491 (12/29/2016)

---

On the flip side there's even more great open data sets to build analysis skills on. Everything from census to the stars, if you want some real data to...

chrisn-585491 (12/29/2016)

---

Microsoft has stumbled some, but has made some great steps with SQL Server, .NET and even cool cross platform tools like VS Code. I'm really enjoying F# and think...

Geoff.Sturdy (12/29/2016)

---

Its odd that Steve considers Brexit and the 2016 presidential election result as representing one of the "craziest" years of his life - we in the UK voted to...

Does this work for you?

If RecordCount > 0 Then

DTS.TaskResult = Dts.Results.Failure

You should be able to do this, but it's possible that you are using some features or expecting something in the destination currently that doesn't work (or is changed) in...

Are these both writeable? Meaning can data change on both sides? There isn't a good way to sync these if both can change. Merge replication works, but it's cumbersome -...

I hope it ends soon.

🙁

that's a better choice. Putting functions in the WHERE clause means all rows need to be evaluated, which is a scan of the heap or index.

Also note there are lots of scripts on this site that people have shared to do this: http://www.sqlservercentral.com/search/?q=copy+backup+files&t=s&sort=relevance

Please post new questions in a new thread in the future.

In this case, you would have to perform some more debugging. One common cause is that the account running xp_cmdshell...

I hate in place upgrades. They are asking for problems if there is an issue, and that could happen. If you must, then you need to go to sP2.

I much...

Not as much fun though. Plus, Grant maybe learned from me. He doesn't drive enough to make it worthwhile.