What is e? I do not see it specified. I assume you want to alias your subquery. If that is the case your subquery is not returning that column.

EDIT:Saw...

Hi Ron,

I don't see anything in that reference to dbo or specific to the EXECUTE permission. Can you elaborate on issues with granting the exec permission on the dbo schema...

Add an s to make service services.

USE databaseName

GRANT EXEC ON SCHEMA::dbo TO userName

That should do the trick, assuming the schema for these objects is dbo! Else, replace dbo with the schema you need.

That means your login does not have permission to login. Have your DBA check on this for you.

cw.izatt (2/13/2012)

---

Jeff Moden (1/9/2012)

---

@cw.izatt ,

Did you actually check for an absence of FKs or just an absence of PKs? I ask because UNIQUE constraints will suffice for the instantiation...

Here is a better option:http://blog.universql.com/sql-server-2005/the-ssis-subsystem-failed-to-load/

EDIT: 1 more for good luck! http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/71216/

Run this before inserting the row:

EXEC sp_configure 'allow updates', 1

reconfigure with override

Then this after:

EXEC sp_configure 'allow updates', 0

reconfigure with override

However, I don't advise inserting rows into system databases. You...

Hi Gary,

You question is going to be addressed much quicker on an asp.net forum. This is not an SQL Server issue really, and so you are not likely to get...

Always check what the error tells you first 🙂 Saves a lot of time.

Also, is SSIS installed properly? Is SSIS running? What account is it running under?

Why do you think 1 row is missing and why did you add it manually? What type of package are you trying to run (was it created as a maintenance...

It depends on the...

Sorry... Thanks Gail.

Did you see this one?http://msdn.microsoft.com/en-us/library/ms186734.aspx I think this is pretty good.