Allright. I just went over Gianluca's (incredibly complex) article.

Did almost everything. Just the configuration of the MSDTC I couldn't do, as I apparently have only the option to configure the...

Tom.Thomson (7/28/2011)

---

But there's a glaring syntax error connection string in the script in your message (missing quote at end of one of the string parameters). So I have to...

Ignacio A. Salom Rangel (7/28/2011)

---

That is the approach I always take and in my case it works. While on SSMS can you browse the link server tables? Have your account...

Great question, thanks.

Great and clear example. Thanks Tom.

OK, forget about testing ODBC in SSIS, the system DSN is created on the server, together with the Client Access software.

Which I both don't have on my local PC.

Anyway, OLE...

I only tested SSIS with OLE DB.

I shall test it with ODBC right away! 🙂

edit: there is no windows security, I use a fixed login and password to connect to...

Thanks for the reply Gianluca.

However, I can rule out A through D, as I can create a successful connection and extract data from it in SSIS.

So it is somewhere in...

If any of you guru's can shed a light on my issue, that would be great!

http://www.sqlservercentral.com/Forums/Topic1149829-391-1.aspx

Thanks!

In most cases you can...

darkfour (7/27/2011)

---

Question: Do you have certifications

Comment: This is rather disappointing point for me. Qualifications generally are welcome but unfortunately many people simply cheat. Companies run courses and then give questions...

Kiara (7/27/2011)

---

Ah, but you are leaving out the unknown percentage of...

cengland0 (7/27/2011)

---

I own my own business (wbttools.com) and consider myself an expert on quiz technologies. I have...

Ninja's_RGR'us (7/27/2011)

---

cengland0 (7/27/2011)

---

None...

8 posts complimenting...