Tags » SSIS

Extending SSIS With .NET scripting

Earlier this year I got embarked on a book project together with Joost Van Rossum (B|T) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. 154 more words


Great Tool For Your ETL Toolkit - CSVed CSV/Text Editor

CSVed to the Rescue

If you work with large text input files in your BI process, a good CSV/Text editor is a must have addition in your toolkit. 373 more words



Here are some final notes on this topic. I’m going to describe an import I did recently, and hope this may help you decide where OPENROWSET and BULK INSERT could fit into your development activity and what tools you might use. 913 more words

SQL Server

Warehousing and BI

We just completed a data profiling project focusing on the manufacturing end of the business.  This project was so successful that the COO of our company has become the sponsor of the development of a data warehouse. 273 more words


SSIS – Configuring SSIS Package to run job after data loading has completed

  • In our example below, we are going to be using a SharePoint 2013 Data Alert job which was created in SQL Server Agent, and then…
  • 659 more words

How to loop over a SQL Server BIGINT collection using a SSIS Int64 Variable

When you work with SSIS in a Data Warehouse environment as I do you’ll often need to process data on a daily base. Therefore your loading processes need to be able to loop over a bunch of data from a source system. 686 more words


Retrieve SSAS cube data into excel file using SSIS

/01. Create a table/

use TrainingDB
create table mdxData (category varchar(100),subcategory varchar(100),product varchar(100),SalesAmt varchar(100),taxAmt varchar(100))

/02. Create a Stored Procedure which  insert MDx data into a table… 178 more words