Tags » SSDT

SSIS Data Import Script Task

Aim: To use an SSIS Script Task to import csv files where the metadata is different for each file.

Recently I had a task to do a one-off import of data from a large number of csv files where the metadata was different for each file. 1,119 more words


Aggregation Design is Back!

If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012 development, then you have no doubt been frustrated, like me, by the fact that if you have both of these installed you no longer have the ability to create new Partitions and AggregationDesigns when working with the SSAS MOLAP model.   115 more words

SQL Server

One Tool to Rule Them All – Almost

There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One Tool to Rule Them All”. The SQL Server Data Tools (SSDT) teams and the Visual Studio (VS) team have finally teamed up together to give us one tool to do all our development work for Databases, SSIS, SSAS & SSRS. 557 more words

SQL Server

My Build and Deploy Process (as Requested by Bill Fellows)

Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS Summit, you can read about my… 874 more words


SQL Server Data Tools is now a separate installer - Things to know!

Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I had previously used SQL Server Data Tools, and I tried to search for it under Programs. 180 more words

Tools & Features

Issue Installing SSDT-BI 2013 on Windows 10

So, a week ago, once the initial excitement of having Windows 10 had died down, and the reality of re-installing all of my applications on my PC had dawned, I was busy doing just that. 163 more words


SQL Development Tools–I need what version?

Being a SQL DBA and part time SSRS developer, I sometimes get very confused and lost in what version of BIDS  or SSDT (SQL Server Data Tools) I need for what version of SQL. 317 more words