Simply renaming the file won't help much if the xlsx file is truly in Excel format and not simply a CSV file with an xlsx extension. Open the xlsx file...

sqlstud (1/16/2013)

---

Hi,

I am loading the table from Excel source using SSIS 2005.

Excel contains one of the columns as Exp_Date and its examples values are

10/09/2010 17:00:51

11/09/2010 11:45:16

11/09/2010...

dwain.c (1/16/2013)

---

opc.three (1/12/2013)

---

Not a problem. I hadn't played with unpivoting data in a long time so I took it on as a learning challenge. It took me about a half...

A plug for our sponsors:

redgate SQL Prompt can optionally decrypt objects compiled WITH ENCRYPTION for you right within an SSMS Query window. Encrypted objects appear decrypted when you hover over...

Have you had a look at config files?

http://msdn.microsoft.com/en-us/library/dd239405(v=sql.110).aspx

All I can say is maybe start tracing activity on the MySQL side to see if you can capture what is coming across when it fails and compare that to...

Is that different from the other tables that are working?

Do you have a copy of MySQL Workbench installed? If you use it to connect to the database and navigate to the table there will be an indicator on one...

How about the storage engine (e.g. InnoDB) of the tables you're having trouble with? Any patterns there?

That's the nice thing about using PowerShell to manage SQL Server. It leverages SQLDMO which works with SQL Server 2000 (SP3 I think) and above.

Regarding CMS, that's a bummer. I...

Here is another syntax for your consideration:

http://www.sqlservercentral.com/Forums/FindPost1407497.aspx

Can you post the actual execution plans for both versions of the query? The one without the hint and the one with the hint?

zinminmaungmaung (1/16/2013)

---

(1) We have some softwares that only compatible with SQL 2008, unfortunately we only can purchased SQL 2012 license in the market.

My first quetion is, can we just...

sqlnaive (1/16/2013)

---

Fortunately or unfortunately, it is the same table. That was also in my mind. But I don't understand that how it is not giving any issue currently as it...

An SSIS package is just a set of instructions. If you kick off dtexec.exe three times in three different cmd shell windows and all call the same package then you'll...