Tags » SSIS

NJSSUG SSIS Performance Tuning

On November 18, 2015 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning.   As promised I wanted to make available the demos… 16 more words


Does cube partition exists? Script task in SSIS explained!

The first necessary step in dynamically creating cube partitions is to determine if the partition already exists. If the partition does not exists then we create the partition, if it does exists we simply process the existing partition. 560 more words


Processing SSAS Cubes with SSIS –Q & A

For those of you who attended my webinar on Processing SSAS cubes with SSIS, thank you! For those of you who didn’t the video is still available here: … 354 more words


How To Get Output messages from SSIS DB Catalog (SSISDB.catalog)

While designing SSIS packages ( before SQL Server 2012) we got used to viewing the log from output window in Visual Studio.
Once you deploy your package to the Integration Services Catalog and execute it you are now presented with tons of information about your package. 111 more words


SQL Server Integration Services - Foreach Loop Container

In my previous article I wrote about the For loop Container. In this article I will show how we can implement the Foreach loop container with a demo. 273 more words

Microsoft SQL Server

Wrox Microsoft SQL Server 2014 Integration Services Book

Here comes the Profession series of SQL Server 2014 Integration Services book from Wrox. Thanks to all authors for such a nice piece!