My Submitted Sessions for SqlBits 10

Posted by on Dec 16, 2011 in Presentations, SSIS | No Comments

Dear folks, I’ve submitted two sessions in SqlBits 10, with these topics: SSIS Programming; SSIS Can Do Everything! Boost SSIS power with XML Topics are in one hour sessions details of each topic are : SSIS Programming; SSIS Can Do Everything! Level: 400 Description: SSIS is a RAD tool and many SSIS Developers only need ...

Read More

Regular Expression in SSIS

Posted by on Oct 28, 2011 in SQL Server, SSIS | No Comments

Regular Expressions are very useful expressions for text processing there are many usages like validation a text against a pattern or find appropriate parts of text with defined patterns which can be solved with Regular Expressions. To find out more about Regular Expressions read here. Today I find a simple case of such things in ...

Read More

Notify Operator Task – SSIS

Posted by on Oct 3, 2011 in SQL Server, SSIS | No Comments

Messaging is one of the most useful features of SSIS. Actually if you want to make a robust and fault tolerant package you need to design logging on errors and warnings properly. there are some options for send notifications in SSIS; Send Mail Task, Script Task ( scripting exactly any type of message ) and ...

Read More

T-SQL Gregorian To Persian Converter

Posted by on Aug 25, 2011 in SQL Server, T-SQL | No Comments

There are lots of times which you need a "Gregorian to Persian ( Shamsi ) Converter" in t-sql. below code will convert gregorian date string for example 2011-08-25 to persian or shamsi date string for example 1390-06-03 . just note this code will work on sql server 2005 or above because I used the Floor ...

Read More

I will Speak at SqlBits

Posted by on Aug 16, 2011 in Presentations, SSIS | No Comments

I will speak at SqlBits 9 At Liverpool about "Programming SSIS" The SqlBits 9 will start from 29 September to 1 October 2011 at Liverpool Adelphi Hotel. Full Agenda of event listed here. My Speaking session is at Saturday, 1st of October at 10:50 AM, with the "Programming SSIS" title. this is a short overview ...

Read More

SSIS 2011 Denali Expression Task

Posted by on Jul 13, 2011 in SQL Server, SSIS | No Comments

SSIS Denali 2011 CTP 3 released at 12 July 2011, you can get it from here, If you try SSIS Denali you will see a new task in Control flow, named Expression Task. In this post I’ll talk about the Expression Task; Expression Task created to do assignment on package variables or parameters. you can ...

Read More

SSIS Upsert With Lookup Transform

Posted by on Jul 12, 2011 in ETL, SQL Server, SSIS | No Comments

This is a very common question everywhere; how can I check if data is exists in destination table then update it, otherwise insert new records. This Scenario named Upsert in common ( Update / Insert ), there are lots of ways to do it, but in this post I’ll describe how to do it with ...

Read More

My Submitted Sessions to SqlBits

Posted by on Jul 11, 2011 in Presentations, SQL Server, SSIS | No Comments

Dear friends, I’ve submitted two sessions at http://www.sqlbits.com  for 29th September to 1st October 2011 at Liverpool. sessions are open to vote already, and you can vote any sessions you like, for voting you can go here and vote from 108 sessions. my submitted sessions are : Programming SSIS SSIS Programming seems to be a ...

Read More