IT Systems – Short Circuit Electronics

Importing Excel XLS to SQL SSIS error

While trying to execute an SSIS import package on a customer’s Excel file, SQL Server 2008 SP1 was returning a “truncated” error. Although, the SSIS package was set to ignore these, the execution halted and data was not written to the SQL table.

There were a number of posts including David Klein’s and Waxtadpoles regarding SQL 2005 and the “TypeGuessRows” setting in the registry. Their suggestion was to set the value to 0 (zero), in order to force ...

Continue Reading →

2
MAR

0

Share

IT Systems

32bit, 64bit, Error, Import Excel, Mac, OS, SQL 2005, SQL 2008, SQL Server, SSIS, truncating, truncation, XLS

iPhone suddenly drains battery due to constant push polling

One of our users suddenly began experiencing a severe draining on his iPhone battery. There are variety responses to this topic, the least of which was to change the iPhones mail retrevial from Push to Fetch. Howver, other iPhone users were not experienceing this issue. So we set out to troubleshoot what was happening. After two days of research, below is our results and the resolutin that worked for us.

Constant polling in Push mode

The first thing we detirmined ...

Continue Reading →

6
NOV

12

Share

IT Systems

ActiveSync, Error, Exchange, Exchange Account, fetch, OS