SQLKnowItAll (3/12/2012)

---

Welsh Corgi (3/12/2012)

---

SQLKnowItAll (3/12/2012)

---

Welsh Corgi (3/12/2012)

---

Pam Brisjar (3/12/2012)

---

No problemo, Sean. But I do agree with you that we need to see the exact query that's producung the error. After...

Pam Brisjar (3/12/2012)

---

To consolidate and repeat what has been said above, if you are using OPENQUERY, you must use:

SELECT *

FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM Company WHERE EFF0YR = ''112'' AND...

SQLKnowItAll (3/12/2012)

---

Welsh Corgi (3/12/2012)

---

Pam Brisjar (3/12/2012)

---

No problemo, Sean. But I do agree with you that we need to see the exact query that's producung the error. After all, I could...

Thank you....

I...

Msg...

I ran the query on the Server using a toll called SQuirrel without error.

I ran the query on the Server using a toll called SQuirrel without error.

I did not create this Database CSC Did and it is not fun to work with

I tried the additional quotes but it did not return any data?

Unfortunately we do not hist this system. It is licensed to it and it is going away but not before I start performing the incremental loads.

So changing the source with...

Thanks those 3rd party controls look nice but I was trying to get around not having to purchase it.

I have too much data and I doubt that I could get...

I'm just trying to figure out the best way to do this.

Since the Data is not SQL Server, DB2 in this case, I can't use a merge or OUTER JOIN...

Have you ever used SSIS for an incremental load into SQL Server with a data source other than SQL Server?

In addition to the complete error message, what are you doing when you get this error?