terryshamir (8/17/2011)

---

Hi I'm porting an Access DB to SQL Server 2008.

Unfortunately there is an excel spreadsheet that gets sent to customers who fill it in, when we get it back...

What character encoding is used in the file? If the file is UCS-2 (i.e. "Unicode" in Windows-speak) the character may be the Unicode version (UCS-2 0x20A4) and not the Windows-1252...

You need to explicitly create the Credential on the prod instance, and link...

Some options for you in no particular order:

- Use xp_CmdShell to issue a DEL command directly

- Use xp_CmdShell to call a Windows...

Blatant! I love it 😀

Impressive TOC...Chapter 42 alone is worth the coin 😉

shew (8/13/2011)

---

Hmmm. Sounds like that would work for batch jobs, but I would like something that would handle interactive commands too (so I can test in the exact same...

GilaMonster (8/16/2011)

---

opc.three (8/15/2011)

---

I read a post on SSC earlier today, which of course I cannot find now, that talked about the spid in the graph possibly being the deadlock monitoring...

It must be in the water or something...it's funny how somewhat rare items tend to surface in bunches on these forums. I turned on 1222 last week and have had...

Yikes! I read where running an additional trace, to cast a wider net, was sometimes necessary to see what other SQL was participating in a deadlock. I was most certainly...

I am not sure I can solve the issue by changing where PS will look to load a profile script, but I may have a workaround for you. Since this...

Yes, it is worth turning on. What else is running on the server? It sounds like something else may...

CLR can bring a brevity to your code not offered by T-SQL and in some cases can exceed the performance offered by native T-SQL.

Here is one example for a string-concatenation...

YSLGuru (8/11/2011)

---

You see the problem is that the most effeciebt way to process the query is not the same trhoughout our cycle which is a month. Sometimes the query hint...

Use a Script Task.

This is not strictly an SSIS problem. You may have better luck finding examples on .NET/Office-specific programming sites. Google/Bing will be your friend.

MIKEKREIS (8/11/2011)

---

Does anyone know if it is possible to run some VB code (or c# code) through SSIS to make the sheet more "readble"? Like deleting the blank lines, or...