LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "sql server data tools"

SQL 2014 CTP1, where is my BIDS?

Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here’s a nice overview:

BIDS or Business Intelligence…

Read More...

Database Projects – Setting up Source Control

For some time I wanted to document the possibilities of the SQL Server Database Project and how developers and DBA’s can benefit from it.
Problem Statement
Many companies I’ve worked for struggle with their database lifecycle management:

Producti…

Read More...

Where are the Data Sources and Data Source Views in SSIS 2012?

While I’m still preparing to teach a MS6235A SSIS training I use a SQL 2012 RTM environment to test the demo’s. One of the demo’s is to show how a Connection Manager is made based on a Data Source View. In BIDS 2008 the Data Sources and Data Source View…

Read More...