You cannot open the BIM file. Reason: You are not an Administrator on the workspace database server

Most of us might get this error message when we start to work on SSAS tabular model in client sides.

The solution is very straight forward but this can’t be solved by same login which is getting this error message. Contact the SQL Server administrator or use "sa" login and add your username under Sever administrators list in SSAS as shown below.

Cheers! Uma

How to connect PostgreSQL database in SSIS

In these days most of the databases are migrated to Could databases such as Azure SQL Database. In here I would share my experience that PostgreSQL as source for SSIS.

There are many connectors available for PostgreSQL, however most of them are not free. I found the free connector with latest update in the following link:

https://www.postgresql.org/ftp/odbc/versions/msi/

You can download based on the source architecture

The easiest way is creating a ODBC connection for PostgreSQL and connect via ODBC source in SSIS.

The following screenshots illustrates the ways to create a ODBC connection.

Once you establish your ODBC connection use ODBC source to connect.

Cheers!
Uma