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[…]
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 about My Submitted Sessions to SqlBits[…]
The Audit Transformation in SSIS Data Flow task purposed to fetch some of system variables besides data stream columns to create a log for data stream, You can audit transformation with source columns to have columns data besides audit information like guid of package, name of data flow task, time of execution and few other Read more about SSIS Audit Transformation[…]
SSIS Configuration is a handy option in SSIS deployment. there are lots of scenarios which can be implement with SSIS Configuration. in this post I don’t want to explain what configuration is , you can read more about it here: http://msdn.microsoft.com/en-us/library/ms141682.aspx There are two types of configuration: Direct and Indirect. in Direct configuration, the configuration Read more about SQL Server Indirect Configuration – SSIS[…]