Tags » SSIS

SSIS Lookup Gotcha - Test Fully

The task I had on my hands was simple. I had to perform lookup on a target table with my source data and get all non matched data. 392 more words

Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

I recently got a new laptop and had to go through the ritual of reinstalling all my programs and drivers. I sometimes work with SSIS locally to import data from Excel and occasionally do demos with Power BI where I read from an Access database so I needed to install the ACE OLE DB provider.   278 more words

Microsoft Technologies

Compressing files from the SSIS Script Task

I hate SSIS. It seems to me that it is full of certain nuances and unless you are regularly developing SSIS packages, they are easy to forget or it is easy to miss specific important steps. 384 more words

SQLServerPedia Syndication

avoid time-out for Denodo ADO Net Source in SSIS

In SSIS, I was executing sql command in ADO Net Source of one of the Data Flow and was getting Time-out error after approximately 15 minutes. 33 more words

SSIS

Performance Tuning in SSIS for Denodo ADO Net Source

Assumption: You have Denodo driver installed on server. (I had used “DenodoODBC Unicode” version 9.03.04.00, when I created User DSN)

Below steps helped me import two million rows (6 columns with mostly int data) data in less than 4 minutes. 119 more words

SQL Server

SQL Server 2017 - RC1 - Upgrade und Installation

Der erste Release Candidate der SQL Server 2017 Version wurde am 17. Juli veröffentlicht. Die enthaltenen Feature und Erweiterungen habe ich in einem Ankündigungspost zusammengefasst. 420 more words

SQL Server