Hi folks, the event schedule of SQL Saturday 136 of ANZ 2012 defined already, This event will be in Wellington at 14 April, Agenda of 14 sessions listed here. You can register for this free tutorial day of SQL Server and enjoy it. there are a range of good SQL Server speakers there which I Read more about My Session at SQL Saturday 136 Wellington[…]
Hi friends, after about 7 month hardworking I wants to inform you that my upcoming book about SSIS 2012 will be published about 1 month later, So I like to share the link of the book here. Pedro Perfeito one of my friends who is a SSIS expert and also SQL Server MVP in Portugal Read more about My new SSIS 2012 Book Will be Published Soon[…]
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 about My Submitted Sessions for SqlBits 10[…]
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 about Regular Expression in SSIS[…]
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 about Notify Operator Task – SSIS[…]
Finally the SQL Server MVP Deep Dive Volume 2 going to be available soon . This book is all about SQL Server, but not an ordinal book about SQL Server from begin to end or on special aspect of SQL Server. This book covers 5 major topics of SQL Server ( Architecture and Design, Administration, Read more about My Contribution in SQL Server MVP Deep Dive Volume 2[…]
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 about I will Speak at SqlBits[…]
Using dynamic t-sql is one of the good abilities in SQL Server, and there are times which you need to do this in SSIS. Suppose you have a data stream in SSIS Data flow task and you want to run a dynamic t-sql query per each data row values, probably your first stop is OLE Read more about How To Run Dynamic T-SQL In SSIS OLE DB Command[…]
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 about SSIS 2011 Denali Expression Task[…]
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 about SSIS Upsert With Lookup Transform[…]