How about "daytah" vs. "dahtah"?

You have the LIKE statement backwards and you need to supply the wild card like below

select distinct convicted.*

from convicted

join monitor

on convicted.defendant like monitor.name + '%'

and monitor.birthdate =...

Are there multiple SQL Servers involved in the process? If there are you will need DTC running and configured correctly on all the servers.

If your data changes (inserts/updates/deletes) are...

Have you gone to the properties of the connection manager and using the expressions set the ConnectionString property to the variable?

This blog post explains it and has images, http://kevine323.blogspot.com/2012/04/dynamic-connection-strings-in-ssis.html. ...

Does the server exist?

Can you connect to it using SSMS?

Does the server have Integration Services installed?

Do you have permissions in the catalog?

Jack Corbett (8/10/2015)

---

Igor_IM (8/10/2015)

---

Hello. Thanks for the response. I got the point concerning NOLOCK... Anyway I came to the conclusion there is an issue with db lock when...

Igor_IM (8/10/2015)

---

Hello. Thanks for the response. I got the point concerning NOLOCK... Anyway I came to the conclusion there is an issue with db lock when I run SELECT *...

The OPTION has to be the last clause in the query so must be after the GROUP BY.

The company I'm at currently does team building. Each department gets a budget for one departmental outing per year, and it usually is a pretty good time. I...

I don't necessarily have everything in a utility database, but I do have a bunch of things I use regularly as snippets in SQL Prompt. Like Itzik's virtual numbers...

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack in interviews published?...

Alvin Ramard (8/3/2015)

---

SQLRNNR (8/3/2015)

---

Lynn Pettis (8/3/2015)

---

Read the following comment made today by Silver Spoon on a 4 year old thread:

ok, thank you very much.

I inherited these databases so I'm very...

Cadavre (7/31/2015)

---

Brandie Tarvin (7/30/2015)

---

Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance...

Grant Fritchey (7/30/2015)

---

Brandie Tarvin (7/30/2015)

---

Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve...

Brandie Tarvin (7/27/2015)

---

SQLRNNR (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for bring up the topic,...