Tag Archives: SSIS

SQL Server 2016 Management Studio Download

It’s that time of the year. No, I’m not talking about christmas, I’m talking about new product cycles from Microsoft. For SQL Server it usually happens on even years, it’s 2016 so this year we have a new SQL Version. … Continue reading

Posted in SQLServer | Tagged , , , , , , , , , | Leave a comment

Get a taste on the cloud: MS Azure Free Trial

Continuing with the inevitable move to the sky, and trying to self-quote myself here (well, self-post actually), I’m back to tell you that you can have one month of free experimentation with all Azure platform for free. You can set-up … Continue reading

Posted in Azure, BI, Cloud, SQLServer, Windows | Tagged , , , , , , | Leave a comment

Some fancy BI stuff: SSIS training, Data Tools add-ins and BIML academy

A few days ago I posted a link to one BIML introduction webcast. Now I now it will be a series of webcasts this week, it’s a great oportunity to learn more about it! Stay tuned and subscribe to the … Continue reading

Posted in BI, SQLServer | Tagged , , , , | Leave a comment

SSIS / Data Tools compatibility between 2014 and 2012

Well, to be simple: there is no backwards compatibility when you create a package in SQL Server 2014 Data Tools (formerly SSIS/BIDS). 2014 files only run on 2014 servers. 2012 on 2012, and that’s it. Microsoft acknowledge this issue but … Continue reading

Posted in BI, SQLServer | Tagged , , , | Leave a comment

SSIS: Integration Packages on 64bits

And so I’m back to designing SSIS packages. Its a fun activity really. SQL Server Integration Services is a really powerfull platform to move data around. It can read anything and write anywhere (and even if it can’t directly access … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

SQL Job with Maintenance Plan misteriously failing

This post is to group details about one possible cause of failure on SQL Agent Jobs that have Maintenance Plans inside. Because the Job engine is not very clever when storing the messages returned from the SSIS Package (that is … Continue reading

Posted in SQLServer | Tagged , , , , | Leave a comment