Still no Microsoft BI App…but PushBI is available!


About PushBI
PushBI Mobile is a one-of-a-kind mobile business intelligence solution. So simple, it’s almost hard to believe. PushBI Mobile is designed to turn your business into a mobile business intelligence powerhouse – almost overnight.

Platform support

Phones: iPhone, Android, Windows, BlackBerry
Tablets: iPad, Windows Slate, Honeycomb, Cisco Cius and Embedded CE
Desktop: Windows XP and 7
Databases: Microsoft SQL, Oracle, SAP BW, DB2, Azure and others
Other Data sources: SharePoint, Excel, XML and others

A short promo video

Advertisements

Product Guide for SQL Server ‘Denali’ was released today!

The Product Guide package includes:

– 14 Product Datasheets
– 8 PowerPoint Presentations
– 5 Technical White Papers
– 13 Hands-On Lab Preview Documents
– 6 Click-Through Demonstrations
– 13 Self-Running Demonstrations
– 26 Links to On-Line References
– 44 Links to On-Line Videos including 26 Presentations from North America TechEd 2011

Download it here.

SSIS / SQLCMD: Delete old TXT files

An easy way to delete old TXT files on your server is to use a SQL Agent Job and can be used with my previous GenerateScripts SP’s.

For this, I wrote a SP that uses the SQLCMD utility of SQL Server instead of SSIS because it’s lean and easy to implement.

A simple folder lookup by using SQLCMD:

I wrote to different Stored Procedures:
– Delete TXT files based on the file’s filename (for example:’_yyyymmdd‘)
– Delete TXT files based on the file’s creation/modification date

Download both SP’s here:
sp_DeleteOldTXTFiles

SSIS Excel Source error -”Text was truncated or one or more characters had no match in the target code page.”

How to increase the number of rows in the Excel file that SSIS validates on metadata:

The Jet OLE DB provider reads a registry key to determine how many rows are to be read to guess the type of the source column. The registry setting is:

HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows

By default, the value for this key is 8. Hence, the provider scans the first 8 rows of the source data to determine the data types for the columns. If any field looks like text and the length of data is more than 255 characters, the column is typed as a memo field. So, if there is no data with a length greater than 255 characters in the first 8 rows of the source, Jet cannot accurately determine the nature of the data type.

The valid range of values for the TypeGuessRows key is 0 to 16. However, if the value is 0, the number of source rows scanned is 16384. Keep in mind that a value of zero may cause a small performance hit if the source file is very large.

Source

How to:

To change the value of TypeGuessRows, use these steps:
On the Start menu, click Run. In the Run dialog box, type Regedt32, and then click OK.
Open the following key in the Registry editor:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Note For 64-bit systems, the corresponding key is as follows:

HKLM\SOFTWARE\wow6432node\microsoft\jet\4.0\engines\excel
Double-click TypeGuessRows.
In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 and 16, inclusive, for Value data.
Click OK, and then exit the Registry Editor.
A second way to work around this problem (without modifying the registry) is to make sure that rows with fields, which have data 255 characters or greater, are present in the first 8 rows of the source data file.

This solution may also be used for ‘Mixed data types in Excel column’.