Koen Verbeeck (1/13/2015)

---

Jimmy123 (1/13/2015)

---

At SSIS at 2008, it will only scan 16483 records max with typeguessrows set to 0 as Microsoft have capped it at this. This is a common...

Perhaps you are missing a comma?

See if this article addresses your problem:

http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/

- Brian

Note that DepartmentName is Unicode which means that there are 2 bytes per character, and DATALENGTH(Ms) returns 60 because it returns the number of bytes, not the number of characters,...

Just to clarify, the default block size is 65536 (64 K) bytes for tape devices and 512 bytes otherwise. According to the referred MSDN page, the BLOCKSIZE option is typically...

I believe the Linked Server UI he is referring to is the dialog box you get when you right click on Linked Servers (underneath Server Objects in SQL Server Management...

Have you looked at using an add-in like SSMSBoost?

You might want to take a look at http://support.microsoft.com/kb/316934 to see if it addresses the problem you are trying to solve.

Why are you using String.Format()? I don't think it's needed, but it's not what's causing your problem - you get the same INSERT or UPDATE statement whether you surround it...

Okay, I think I see what you're doing. Could you provide the schemas for TableA, TableB, and for NO_SLR_CODE$

Maybe I'm missing something but I see a common table expression NO_SLR_CTE but the CommandText of your ExcelUpdateCommand (and that of your ExcelInsertCommand) refers to NO_SLR_CODE$. Is NO_SLR_CODE$ supposed to...

Nice article. Apparently in the editing of the article content, some minor inconsistencies were left in toward the end. In the paragraph that begins "Let's make it a bit more...