SQL Server Data type conversion is one of the most common tasks in any ETL process. There are several ways of data conversion in SSIS. We have Special “Data Conversion” transformation task or we can use derive column to change data type of a column or we can change the data type while reading […]
In my previous post Introduction: SQL Azure; we had a brief introduction of SQL Azure and how this is different from SQL Server. This blog post will illustrate “How to create database” in SQL Azure (SQL Azure Creating your First Database).
To create a database in SQL Azure (Evolution Edition), all you need is a […]
SQL Azure Introduction
SQL Azure is part of Microsoft Azure Service Platform which provides data storage/manipulations capabilities to the platform. SQL Azure uses a special version of SQL Server as backend. This provides two editions of database namely Business Edition and Web Edition. Maximum database size in Business edition can be of 150 GB and […]
In my previous post, I have discussed about various options available in SSIS to load multiple flat files. One of the mentioned options is using “MultiFlatFile”. A multi flat file connection allows us to access multiple files in parallel i.e. we can read data from multiple files in parallel and it produces data as […]
Many times we require to import multiple files in SSIS. There are various ways to achieve this and the best option depends upon on case to case. The available options are:
For Each Loop and a variable to create dynamic connection
In Single dataflow, use separate Connection for different files and use “Union All” or separate […]
model database is one of the sytem databases that act as a template database for creating new database, also the size of new database should be greater or equal to model database. We can create, modify and drop objects in the Model database. The newly created database will have all the DB objects including […]
Many times we are in need of cross-references between SQL Server data types and the data types available with SQL Server Integration Services. This is very much needed when we require to set a variable in SSIS from a result set returned from Execute SQL Task or when we need to pass parameters to […]
Till now, SSRS does not support Cascading Style Sheets (CSS) or themes & skins that are available with HTML or .Net development. The approach that I am going to describe is very helpful and I hope it will increase productivity by avoiding repetitive and laborious report element formatting that we usually do during report development. […]
SQL Server family has various services like Database Services (SQL Server), Analysis Services, Reporting Services which supports Named Instance of the services but there are few others like Integration Services which does support named instance. This means, we can have one and only one service of Integration Services on each server.
By default, the MSDB […]
SQL Server 2008 R2 Express, a free edition of SQL Server is ideal for learning and building applications for desktops, servers and the web.
One of the biggest changes from its previous versions is the maximum size of database that can be supported on Express editions. The current version of Express Edition supports databases of […]