Random thoughts...

Curious, what is @ doing in your command line? This is what I get when I run your code:

Just a hunch...try surrounding your file name...

I guess I had gotten farther than you and missed the issue completely...I thought you were having trouble parsing the XML in the script task. ADO.NET is what I used...glad...

Are you comparing apples to apples...are:

- both connections from SSMS on the same machine?

- both connections from SSMS but on different machines?

- you using SSMS using instance-name and some web...

Kiara is on to something with permissions. Also make sure the user executing the statement that is firing the trigger has permissions to TRUNCATE the table.

That is not a lot of information to provide for a performance problem...there could be a lot of reasons for this type of scenario to arise.

- Are you running it...

You have a point...I read more into this part of the requirement

meaning to me "only delete rows with a NULL City if there is another row...

This deletes both rows where OrderID = 111111 which...

Here is one way for PK = 1:

WITH cte(element)

AS (SELECT CONVERT(XML, '<root><i>' + REPLACE(beforeImage,...

Try this:

WITH cte(OrderID)

AS (SELECT OrderID

...

The return type of ENCRYPTBYKEY is varbinary(8000) http://msdn.microsoft.com/en-us/library/ms174361.aspx

You may want to look into doing something homegrown using SQLCLR, or look around for projects on codeplex or sourceforge.

Sopheap Suy (3/9/2011)

---

Thank you Julie. I am able to manually run this package on a 64 bit server in debug mode. Todd's blog doesn't describe if there is...

Another link...MDX support in Report Builder: http://msdn.microsoft.com/en-us/library/dd220489.aspx

AFAIK Report Builder can be used to build ad hoc reports using a cube as an initial data source.

1. Create and publish a Report Model from an SSAS Cube: http://msdn.microsoft.com/en-us/library/ms345292(v=SQL.105).aspx

2....

What does the error message say?

Sounds like it could be a network route issue. From your machine, what IP does the server name resolve to? Is it the same as the IP address you were...