Security measures are as secure as the password the user uses 😀

You need to specify that in the CREATE TABLE statement.

FieldA needs to be (DT_STR,150,1252), FieldB needs to be (DT_WSTR,150).

TomThomson (9/3/2014)

---

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just...

JoseMenendez (9/3/2014)

---

TY for the rapid response. I have mapped my OLE DB Destination to the converted columns from my Data Conversion but still receive the same error? I...

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this...

Regarding the first error.

When you use the data conversion component, it doesn't convert the column itself. It puts the converted data into a new column.

Don't forget to map this new...

I guess they meant ad-hoc queries?

dndaughtery (9/2/2014)

---

I have a package running from a job and its been running fine for quite some time. It failed recently with the following error but ran fine on the...

What are the errors?

This should work (but of course I can't test it, since you didn't provide any table DDL and sample data).

,[Weekly Rent] = ((COALESCE(CTAX.[NET-AMT],0)+COALESCE(HEAT.[NET-AMT],0)+COALESCE(FURNIT.[NET-AMT],0)+COALESCE(SERVCH.[NET-AMT],0)+COALESCE(SEWER.[NET-AMT],0)+COALESCE(WATER.[NET-AMT],0)) * 12) / 52.0

Be...

Yes. But it needs to work over the different machines.

I have never configured it myself though, I try to avoid it at all costs.

And even more important, the source...

That's the extension for Word 2003.

Did you also comment out WORDOPENXML? That's the one for Word 2007-10.

Is MSDTC configured correctly?

Lynn Pettis (9/2/2014)

---

Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the WHERE clause?

OLE DB provider...