So, I don't feel that I'm doing one of our posters justice on a topic he's posted. I've gotten a very polite blow off. Not looking for a...

Ness (5/13/2013)

---

Many thanks for your messages but I'm not sure that this is the case, this works from time to time - Surely it would be an all or nothing...

Kerberos Double Hop error. Pain in the arse the first time you run into it because the keywords don't make sense, but that's what you've got.

Google up those...

If you can, RDC to the server and crack open the package in BIDS, see what it thinks the metadata changes are supposed to be. Could be something as...

Don't sweat it. Most...

It's not required except for certain pieces at this time, such as ending the previous statement before starting a WITH component.

However, it does no harm and is 'proper' coding, even...

Miles, I used to do a similar process but using linked tables it avoided them keeping local data that needed to be merged later. Made my life so much...

Yeah, either modify that to be one of the logins from the other systems that are working, or check that user's permissions against the target system. My guess is...

then we need to see the target proc and a sample call.

You have to RDC to the box, rt-click computer, manage, and check the services. Rt-click services and in properties for it you'll be able to see the login for...

Lynn Pettis (5/9/2013)

---

Because you have the table alias in the wrong place:

select t.cbclaim from [dev].[stage].[dbo].[claimsview]...

Does your UAT SQL Agent Login and/or...

I'm not sure why or how it would be doing that, but I just wanted to drop you a line. You'll probably get more effecient help going to a...

What's the exact error? Can you copy/paste it from SSMS please?

What user is running the IS Service on that box?