Sorry... Try this:

SELECT *

FROM openquery(MySQL_DB, 'Select * from DB.table LIMIT 0,10')

Can I ask WHY you think this may be a problem?

soulesidibe2011 (2/6/2012)

---

the developer does not want to change his connection string or program at every change, that's why he was requested this.if the name of the server changes, he would...

weston_086 (2/6/2012)

---

Write SQL using the employee table below to create a data set listing the manager id, the manager name, the employee id and the employee name

Employee table – t_emp

emp_idemp_namemanager_id

1Jane...

erik-1043807 (2/6/2012)

---

Hello,

I have a problem which is driving me crazy. I need to extract some data from a MySql database into my data warehouse for analysis purposes. I have setup...

I have to ask this... Why does the data need to be moved? You can report off of your existing database and not affect performance in many cases. You...

You reference in this post, and another, the 71% fragmentation. However, you have not provided the size in pages of the index. Fragmentation on small indexes is unavoidable...

Sean Lange (2/6/2012)

---

SQLKnowItAll (2/6/2012)

---

Sean Lange (2/6/2012)

---

SQLKnowItAll (2/6/2012)

---

I don't get it... I believe this is syntactically wrong, but I don't use try/catch blocks much. It seems wrong that your commit...

Sean Lange (2/6/2012)

---

SQLKnowItAll (2/6/2012)

---

I don't get it... I believe this is syntactically wrong, but I don't use try/catch blocks much. It seems wrong that your commit is inside the...

I don't get it... I believe this is syntactically wrong, but I don't use try/catch blocks much. It seems wrong that your commit is inside the try and then...

Sean Lange (2/2/2012)

---

Given what you need for output that is about all you can do. I just wanted to make sure you understand how much data can be pulled back...

It is the version of SSIS that you have installed on your machine., I believe. Not the server you are connecting to.

Absolutely, you just change the name of the table that it wants to import to. It usually crates its own, but you can select an existing table in the...

Just noticed, it's pretty clear from the error that it...

My guess is that the OP is trying to save an SSIS script generated using SSMS import/export wizard, not BIDS. Am I correct? If I am, which options are...