You could also be experiencing the issue listed here, http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/08/20/error-while-deploying-ssis-2012-project-from-ssdt-to-ssis-catalog-system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client.aspx

Did you check the details on the error as Jayanth suggested?

Can you navigate the catalog in SSMS?

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...