When working with Unicode columns in SQL Server you have to prefix your literals with a capital N to let SQL Server know your literal is also Unicode.

Try it...

Sorry for the earlier ooops-post, I posted an incomplete thought and was getting pulled away so just wiped it.

I was going to point out that you can also add...

I agree your T-SQL solution is simpler than the example code used to...

These CLR aggregates are inspired by the MSDN code sample however they perform much better and allow for sorting (as strings) and alternate delimiters if needed:

http://groupconcat.codeplex.com

Just throwing mud at the wall here...

You may have Excel 2007 installed however I see you're using a .xls extension which is typical for Excel 2003 and before. Try using...

I only mean to say that working through a Linked Server to design your MySQL queries when you don't have the full complement of tools available to discover table and...

I think we're losing some traction...do you have the MySQL command-line client on your machine? It might be easier for you to log into the MySQL instance directly, build your...

sandeep1188 (5/17/2011)

---

SORs$A13:M

select * from [SORs$A13:M]

I want to import more than 100,000 rows but openrowset stops at 65523 rows when I try to import data from excel by specifying...

What is the defined collation on the column you're searching?

Can you please provide the table definition, some sample data and any queries you have tried so far?

If you have doubts...

You can try retrieving the column names from INFORMATION_SCHEMA like this:

EXEC ('SELECT TABLE_SCHEMA,

TABLE_NAME,

COLUMN_NAME

FROM...

Both provided solutions look good but I'll go ahead and pile on a third option since I spent the time messing with it 😀

IF OBJECT_ID(N'tempdb..#dates_and_times') > 0

...

It's possible that SQL Server is trying to use INFORMATION_SCHEMA on the MySQL to expand the * to an explicit column list under the covers and it's failing due to...

When your network admin logged in and ran the package manually on the server did he log in as himself or using the proxy account?

Being that its a third-party component...

Thanks. You won't be able to browse your complete MySQL object hierarchy through the SSMS Linked Server node for the reason I mentioned in my previous post about them not...

Try this:

-- The CTE returns the cat hierarchy:

-- one row for each ancestor-descendant relationship

-- (including the self-relationship for each category)

WITH CTE

...