That last post was almost as long as some of the articles here at SSC. :Whistling:

Duplicate Post.

Direct answers to

http://www.sqlservercentral.com/Forums/Topic899069-338-1.aspx

Trey Staker (4/7/2010)

---

I am too, that's why I...

Would this be of any application to your package?

TransactionOption=Supported rather than TransactionOption=Required ?

Another recommendation is to check security settings of MSDTC.

In the sql job, which method are you using to...

I found the following suggestions.

1. Make sure that you are not using an unsupported tuning option. The following link provides the unsupported tuning options: http://msdn.microsoft.com/en-us/library/ms345360.aspx

2. Ensure that the two SQL...

Is the agent running on a different service account? I'm thinking there may be a permissions issue.

In case you can't get to Glenn's blog link (I couldn't launch it), here is an alternative script that I use. It is not a SQL2K5 script but still...

When you stored the package in the MSDB store on the server, what security settings did you select?

Gift Peddie (4/7/2010)

---

GSquared (4/7/2010)

---

Gift Peddie (4/7/2010)

---

Lynn,

When I say a product comes with limitations I know the current internals...

ksparke (4/7/2010)

---

I get the following error when i assign a value to the string variable - The resuly of the expression @[User::PostTableName] on property "Connection String" cannot be written to...

Jeff Moden (4/7/2010)

---

Gianluca Sartori (4/7/2010)

---

CirquedeSQLeil (4/6/2010)

---

Jeff Moden (4/6/2010)

---

Steve Jones - Editor (4/6/2010)

---

Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631

It seemed to perform the...

You're welcome

I find that result quite interesting. I am glad you found the solution.

Oh bother.

Alvin Ramard (4/7/2010)

---

That's what...

I...