Tags » SSIS

I'm Speaking at IT/Dev Connections 2017

I’m pleased to say that I am speaking at IT/Dev Connections 2017. This year the conference will be held in San Francisco October 23-26. I had a great experience speaking at IT/Dev Connections in 2015, so I am excited to return again this year. 391 more words


PASS East Midlands January 2017 Meetup

I’m getting behind with blogging about events I’ve visited this year so I’m going to post some of the things I’ve attended retrospectively in the hope I can… 266 more words

Export .xls ( excel) to Google sheet using SSRS +SSIS and Python.

I was trying to automate the process of rendering the SSRS report into google sheet. Well I could not find a direct way to do it so I manage to do a workaround. 846 more words


SQL Saturday!!!

Yay!!! I’ll be speaking about Biml at SQL Saturday in Chattanooga in June!
I’m very excited. In typical fashion, I will probably cram too much into the hour, but I’ll try not to. 155 more words


SSIS Error Code: 0xC020801C

If you have ever tried to run or create a SSIS extract package that exports to Excel, you may run into the error below:

Error: Excel Destination failed validation and returned error code 0xC020801C. 239 more words
Hints And Tips

TugaIT 2017 - SSIS Scale-Out slides

Thank you for joining my session at TugaIT 2017. The slides of my SQL Server Integration Services (SSIS) 2017 – Scale-Out talk are available for download here: 27 more words

SQL Server

Import and Export Wizard - Handling Dates in Flat Files

As they say there is first time for everything. Having worked on so many packages all through my career never once I had a need to import a flat file containing dates directly from SQL Server Import and Export Wizard. 998 more words