SSIS Packages executed from Visual Studio Business Intelligence Development Studio – BIDS [Design time] on a 64bit development server goes to unresponsive state during package execution.

Through the use of this blog, I would like to address a common scenario that you would run into when executing a complex SSIS package from within the BIDS environment in a x64 bit development server, where the visual studio- BIDS environment goes to a hanged state during the package execution. When I say a…

4

UNVIPOT TRANSFORMATION WITH A COMBINATION OF SINGLE AND MULTIPLE DESTINATION COLUMNS

It is highly not uncommon that while using Unpivot Transformation in SSIS you feel the need to unpivot the columns to multiple destination columns along with single destination column. Dealing with them individually is easy but together is a little complicated when you think about it but that isn’t the case. Let’s take an example:…

3

SQLAllocHandle on SQL_HANDLE_HENV, from Linux SQLNCLI driver

While connecting to SQL from client application(running on linux server),  using using ‘SQL Native client 11.0 (ODBC) driver for Linux’ we were getting following error message. Error message [root@axxxxxazureapi]#  isql -v< DSN> <USERNAME> <PASSWORD> [IM004][unixODBC][Driver Manager]Driver’s SQLAllocHandle on SQL_HANDLE_HENV failed [ISQL]ERROR: Could not SQLConnect   In my case the issue is related with wrong installation…

2

tmp_ms_ getting appended in temp table while creating deployment script from SSDT

I am Sandeep Chalke from Microsoft Data Access Support Team. My team deals with issues that arise while accessing data from SQL Server. I hope many of you should be acquainted with SSDT (SQL Server Data Tools).  If not, please visit http://msdn.microsoft.com/en-us/data/tools.aspx  for details. Two weeks back I faced an intriguing issue related to SSDT….

2