pondělí 20. října 2014

Balanced Data Distributor for Microsoft SQL Server 2012

When I was installing SSIS Balanced Data Distributor at developer machine without SQL Server 2012 installed, I faced following installation error:
"The installation is not successful. Check the following prerequisites: 1. Either Integration Services or SSDT has to be installed. 2. The version of these components has to be SQL Server 2012 (or future SPs)."

(I had both installed naturaly)

After some searching I discoverred, you cannot install the package on machine where is not SQL server 2012 installed.
Huh? As developer I dont have installed SQL server, why should I? I want only create SSIS packages...
Ok, thanks Microsoft for making developing easy again.
Fortunately, there is a workaround, you have to convice the installer then SQL Server is installed on your machine by adding some keys to register.


  1. Run > regedit
  2. Add following keys:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\DTS\Setup
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\BIDS\Setup
  3. To the both keys add a values:
    SP = 0
    Version = 11.0.2100.60


But there was another problem with installation:

"Problem with this windows installer package. A program run as part of the installation did not finish as expected. Contact your support personnel or package vendor"

In windows log I found:

"Error 1722. There is a problem with this Windows Installer package. A program run as part of the installation did not finish as expected. Contact your support personnel or package vendor. Action RegisterBDD64, location: C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\, command: regsvr32.exe /s "C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxBDD.dll"

Solution:
  1. Download 32bit version, not 64.

Problem solved, all installed.
(Product: Microsoft Balanced Data Distributor for SQL Server 2012 (x86) -- Installation completed successfully.)

Cheers.

pondělí 27. ledna 2014

Cantina Band Piano Sheet Music (easy version)

All music sheets of Cantina Band (from Star Wars: New Hope) were too difficult for me. So I took some found version and very simplified it.

U can watch the result on youtube. I used the Synthesia application.


Links for download:
If You find anything strange, please, let me know in comments :-)