Glad it worked!

TBH all I searched for was "MySQL ODBC 5.1 Driver buffer" (minus the quotes). This thread was number 3 on the results; a sure sign of it...

Hi Bob

Hows it going?

I had a quick Google for you. There seems to be a connection setting which forces the ODBC driver to use a forward only cursor, which looks...

Jeff Moden (1/15/2015)

---

No problem. Thank you very much for your efforts.

I have to admit that when it comes to SSIS, I get totally lost because I don't use it....

Apologies for the delay - a combination of Laptop battery dying, intermittent mobile internet coverage and Visual Studio not liking my Virtual Machine 🙁

Two packages built

One which loads via conventional...

Just for you Jeff, I'll...

Jeff Moden (1/13/2015)

---

Heh... nope. Considering how easy it is for me to do things like this in T-SQL without SSIS, SSIS will always be in the "suffering" category for...

Polymorphist (1/9/2015)

---

i'm connecting it to a Flat File Source, then Derived Column task, then OLE DB Destination. This doesn't seem right to me, but i'm not sure where...

0. Power Pivot is only available with certain Office 2013 Licenses

[/b]

http://sqlblog.com/blogs/marco_russo/archive/2013/02/18/the-right-version-of-excel-2013-for-using-powerpivot-powerpivot-excel.aspx

Regarding running multiple load processes into a partitioned table at the same time..

I have found that most systems have a optimal degree of parallelism which is influenced by number of...

Not according to my dictionary!

t.mozelt (2/11/2014)

---

Hi,

thanks for your interesting article! I would like to run your test scenario but I am stuck with following error:

...

Error: 0x1 at Script Task: System.Reflection.TargetInvocationException: Exception has been thrown...

Brandie Tarvin (12/5/2013)

---

One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement. Microsoft gives...

What I find useful is turning a aggregate function into a windowed function, which saves having to use the "group by" clause

Here is the count(*) used in conjuction with another...

What does DBA Stand for?

Don't Bother Asking (We can't hear you in this ivory tower)

aochss (9/17/2013)

---

Thanks for the tip. Learned two items today. Registration of servers and how to set colors.

Has anyone tried the SSMS Tools pack add-in? Any...