What database are you starting the Service Broker in? What are the settings for that database in SQL 2012, and how do they compare with the 2008 R2 version...

The problem is that how date strings are interpreted are a user/connection settable option, so the SQL Agent's login/connection may have something set differently than your personal account.

Consider the following...

And here's [/url]a stored procedure that automates doing almost anything over a SELECT statement without using Cursors or Loops.

The phase "sent from a macro" is extremely unclear. Thousands...

jonas.kasper (5/16/2012)

---

OK. I could use a bunch of while-loops but hey, I think it's an easy and comfortable way to write my code. And it's neat for the eye...

By the...

Slouch

Jeff Moden (5/15/2012)

---

RBarryYoung (5/15/2012)

---

Eugene Elutin (5/15/2012)

---

jonas.kasper (5/15/2012)

---

Yes I do...

I am creating a job that will send emails every morning showing different data that has occured during the last day. Some...

Actually, I think that you want data type 203 instead of 201 (or 200).

I think that that's an OLEDB error that basically means "I don't know what you're trying to connect me to, but it's sure not OLE DB."

Yeah, I haven't seen this particular anti-pattern since the 80's. My sympathy Norm. 🙁

Check the firewall settings, they can cause exactly this error. (I saw it just last week at a customer site).

nano2nd (5/15/2012)

---

Good lead Barry. I turned on logging and noticed that practically nothing happened, including PostExecute, until I took the data viewer out and let the package run to completion....

That error usually means that that TRN file is corrupt.

Eugene Elutin (5/15/2012)

---

jonas.kasper (5/15/2012)

---

Yes I do...

I am creating a job that will send emails every morning showing different data that has occured during the last day. Some of the data...

thang_ngo_2002 (5/15/2012)

---

@herladygeekedness: user can run it anytime not in plan so I don't want to use schedule

@P Jones: I want to use the simplest way, just install SQL Integration service...